If they are true duplicates from col 1 to the end of the record, how about a simple union to a temporary table and then replacing the table with duplicates with the temporary table? I use this method all the time. Quick and easy.:-) This won't work with a table having a unique key. In that case:

select column into #Temp from tablewithduplicates

group by column

having count(*) > 1.

select uniquekey, a.* into #Temp2 from tablewithduplicates a, #Temp b

where a.column = b.column

Then you can identify which records you want to delete in #Temp2.