Why not just do a select distinct into a new table, Delete the old and then rename the new to the old.