MSQuery Quandary
Mar 3, 2006
Ok,
I need to pull out of the database the oldest invoice for each of my clients. Yet i think either or both of myself and MSQuery criteria are limited in this capacity.
please help.
Effectively
ClientA inv00001
ClientA inv00004
ClientA inv00007
ClientA inv00008
ClientB inv00002
ClientB inv00003
ClientB inv00006
ClientC inv00005
ETC...
Where i need to pull out just the bold records... sql script syntax or MSQuery criteria advice is appreciated.
cheers,
Oosters
View 5 Replies
Jul 8, 1998
HI all,
I`ve a problem to access SQL7 B3 from MSQuery......(simply crash)
(I`ve create DSN from Control Panel and ODBC TEST it`s OK)
Any suggestion?
Thanks
View 2 Replies
View Related
Jul 23, 2005
I have a worksheet written by another programmer that I have to modify.He uses MSquery to extract from a SQl 2003 DB. That part I understandand I can duplicate. The hard part, is that for each row that isdisplayed three additional columns show up (in all seven queries) andin one case he changes the sorting of the query as well. Thesefunctions use the columns output by MSquery. There very simplefunctions and tests. In the SQL I can not find them or any reference tothem. There is no module in VBA. No add-in, just the MSQuery. How canhe do this. What should I be searching in Google to understand thisfeature?
View 1 Replies
View Related
Aug 17, 2007
I am trying to open and query a Microsoft Access "like" database from SQL Server 2000 using OpenDataSource. This will work for a little while, but if I am to update my ASP.NET code base I have to completely reboot the machine for these queries to work again. I also have two reboot the machine periodically because this functionality decides to crap out. I am doing this from a stored procedure. My code looks like this:DECLARE @SelectCode varchar(5000)SET @SelectCode ='SELECT CONVERT(varchar, Value) AS UnitName FROMOPENDATASOURCE(''Microsoft.Jet.OLEDB.4.0'', ''Data Source = "' + @Path + @DataFile + '.fcd";User ID=Admin;Password=;'')...Properties WHERE Property LIKE ''UnitName'''EXEC(@SelectCode)Now, when I am developing on my local machine that uses Windows Authentication, I have absolutely no problems, unless the source file has a schema error.Any ideas?
View 1 Replies
View Related
Oct 10, 2007
Here's my query:
Select top 500 email, custnumber from MailingList order by email
There may be some duplicate email addresses with different custnumbers. What would the query look like to only show records with unique email addresses, but still return the unique custnumbers in the query.
Thanks in advance.
View 9 Replies
View Related
Jul 1, 2004
Hey all, first time poster here.
Cheers!
Enterprise Edition SQL2k sp3a on Win2k3 Enterprise Edition server.
Using BCP to load ~4 million records.
Largest record width is ~350 bytes.
When finished i have over 6 million pages reserved and only about 800 thousand actually used.
Which puts me 'round about 3 rows per page and WAY too much empty space.
YIKES!
Any thoughts as to why this is happening?
Or insight into how BCP handles page allocations that may be different than the typical extent based page allocations for table data?
Thanks!
View 14 Replies
View Related
