Aaron Bertrand has a great article on this topic http://www.sqlperformance.com/2012/12/t-sql-queries/left-anti-semi-join
Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]