TSQL Find Duplicate Rows and remove them.

[Matt_Hirst]

I have a requirement at work to remove row duplicates from a table, but leaving the first occurrence and also the non duplicates in place.

I initially thought select distinct and that gives me a unique set of data, but then I'd need to extract these and back populate the table ~26,000,000 records.

What other options are there?

Matt

 

[Matt_Hirst]

Its a load of address data, there are numerous null fields on certain rows creating duplicate data.

Thanks for the help will look at the above suggestions to see where it leads.

Matt