SELECT DISTINCT COL1 INTO #dup
FROM ToBeAdded
DELETE FROM ToBeAdded
INSERT INTO ToBeAdded SELECT * FROM #dup