Dups

SELECT DISTINCT COL1 INTO #dupFROM ToBeAddedDELETE FROM ToBeAddedINSERT INTO ToBeAdded SELECT * FROM #dup