Except statment
Hello:
I am using the "except" statement to find unique records between two tables in SQL Express 2005.
Each table has approx 87,000 records.
When using just a very small subset of each table, let's say 10 records it works fine but when using the whole 87k records I get back all the records from the table on the left of the "except".
Does anyone know of a record limit to this function?
Thanks
Robert
|