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 |
|
|
|
|
|