Delete duplicate records in SQL database using stored procedure
Posted on 2007-12-04
I have a SQL server 2000 database that has over a million records in it. I need to create a stored procedure that i can run that we check for which records have duplicates and then delete all of the duplicates except for one. The criteria for the duplicates is based on five different columns. I am hoping somebody can give me some guideance on how to do this.