August 15, 2009 at 1:14 pm
Hello:
I am using the except function in SQL Express 2005 to find unique records between two tables.
Each table has Approx 87000 records.
If I use a small subset of each table, let's say 10 records it works fine but when I use the full 87 k then I get back all the records from the table on the left of the except statement in the query.
Does anybody know of record limitations using except?
Thanks
Robert
August 17, 2009 at 6:57 am
To the best of my knowledge there is no row limit on EXCEPT and I wouldn't think that there would be. Are you including the same column list in each use of EXCEPT? Are the tables exactly the same structure?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply