Hi All,

Here is another way of how to remove duplicate records in a smart way in MS SQL. Once you have found your duplicate records, you face the problem of merging multiple records into one without losing any data.

This article takes care of this problem:
http://www.dfarber.com/computer-consulting-blog/2011/12/26/remove-duplicate-records-in-sql.aspx

Regards,

Doron

http://www.dfarber.com