Handle Duplicate Records

-- first declare variables: @Count INT, @i INT, @KeepID GUID/INT/?, and ListOfFields

DECLARE curDups CURSOR FOR 
 SELECT COUNT(1), [ListOfFields]
 FROM [Table and any joins] 
 WHERE [condtion]
 GROUP BY [ListOfFields]
 HAVING COUNT(1) > 1

OPEN curDups
FETCH NEXT FROM curDups INTO @Count, ... ListOfFields variables
WHILE @@FETCH_STATUS = 0 BEGIN
   DECLARE curSub CURSOR FOR
    SELECT ...
    FROM ...
    WHERE [matches ListOfFields]
    ORDER BY -- whatever so that the record you want to KEEP is first, 
--I usually order by ModifiedDate and keep the first one entered

   SET @i = 0
   OPEN curSub
   FETCH NEXT FROM curSub INTO @ID ...
   WHILE @i < @Count BEGIN
      IF @i = 0 BEGIN
         SET @KeepID = @ID
      END
      ELSE BEGIN
          --... execute commands, delete 
      END
      SET @i = @i + 1
      FETCH NEXT FROM curSub INTO @ID ...
   END
   CLOSE curSub
   DEALLOCATE curSub

   FETCH NEXT FROM curDups INTO @Count, ... ListOfFields
END
CLOSE curDups 
DEALLOCATE curDups
GO