Tag Archives: delete duplicates

Validate and delete duplicate records from MSSQL table

I had a situation where Index creation failed and business wants to delete duplicate entries immediately from a specific table. I had to validate the columns which are unique and which had different values. Following is easy script to validate … Continue reading

Posted in SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

Identify and delete duplicate records in a table – SQL

One of the best option is to use CTE, ROW_NUMBER() to identify and delete duplicate records Sample Code/Demo: Note: If one of the column is of type NText, will not be able to sort based on the column and it … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | 2 Comments