MSSQL Tutorial: Delete All But 1 Duplicate Records
declare @id int, @total int /* SELECT COUNT OF POTENTIAL DUPLICATES */ select id, count(id) from [tablename] where [parameters] group by [column name] /* LOOP TO CLEAN UP THE DUPLICATES */ declare aff_crsr cursor...