This is a great explanation of using the new SQL 2k5 operators of INTERSECT and EXCEPT instead of inner and outer joins.
Quote
Raymond Lewallen : New INTERSECT and EXCEPT operators in Sql Server 2005 T-SQL
This is a great explanation of using the new SQL 2k5 operators of INTERSECT and EXCEPT instead of inner and outer joins.
Quote
Raymond Lewallen : New INTERSECT and EXCEPT operators in Sql Server 2005 T-SQL