Cool Tips‎ > ‎

Data Deduplication

 

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

 

 

 

Comments