In another thread someone suggested I use MINUS, but I was under the impression that only Oracle had the MINUS function, does SQL Server 2005 also have this ...

Learn how to use the EXCEPT operator in SQL to compare and contrast data from different queries and filter out unwanted rows. Discover some use cases, limitations, and modifications of the EXCEPT ...