Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag common table expression Rss

   Items 1 to 2 of 2   

Duplicate Detection and Management

Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.  Read more...
By Edward Pollack 2014/04/29 | Source: | Category: duplicate
Rating: |  Discuss |   Briefcase | 6,249 reads

Pros and cons of six SQL table tools

This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.  Read more...
By Andy Owl 2011/12/26 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,621 reads
   Items 1 to 2 of 2   
cte (2)    
t-sql (2)    
derived table (1)    
duplicate (1)    
merge (1)    
mstvf (1)    
table variables (1)    
table-valued function (1)