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 ...

In Microsoft SQL Server, the EXCEPT operator is used to retrieve distinct rows from the left query result set that are not present in the right query result set. It is similar to the MINUS ...