This is a general problem faced by a maintenance team. While importing or exporting data to or from or between databases, the PK is removed accidentally and the table now has lots of duplicate records. The big question for the support staff is how to clean the database? It's simple... [More]