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 option?<BR><BR>(I know I can use NOT EXISTS ...
A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...