Title

Description

Applicability

A quick an easy deduplication    

Uses a CTE and PARTITION clause to identify duplicates and delete them in a single statement.

2000, 2005, 2008, 2008R2, 2012

Identify data that is not a member of both sets

 Uses INTERSECT and EXCEPT to quickly produce a list of items from two identically structured sets that are not members of both.

2000, 2005, 2008, 2008R2, 2012