Removing Duplicate Records using SQL Server 2005

July 29, 2008

[From TechRepublic]

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