Removing Duplicate Records using SQL Server 2005

July 29, 2008

Duplicate records can occur numerous ways, such as loading source files too many times, keying the same data more than once, or from just bad database coding. Having a primary key on your table (and you always should have one) can will in the removal of the duplicate records, but even w/ a primary key it is never a fun task to have handed to you to complete.

The article continues at http://blogs.techrepublic.com.com/datacenter/?p=420