A simple way to delete dups that works on versions earlier than 2005 is:

DELETE EMP

FROM Employees EMP

INNER JOIN

(SELECT MIN(EmpID) AS EmpID, EmpName

FROM Employees

GROUP BY EmpName

HAVING COUNT(*) > 1

) AS DUP ON

EMP.EmpName = DUP.EmpName

AND EMP.EmpID <> DUP.EmpID

Todd Fifield