Back to helping the original user and to discuss your critque of the vernacular. . .

declare @row int

declare @count int

declare @previd int

declare @id int

Create table #killRow

(

...

This code creates a table with duplicates. I copy the data into a temp table adding a row column. You could loop through the temp table by...