wseye
11/21/2018 - 7:51 AM

Remove Dupes

removedupes.sql
content_copyfile_download
;WITH cte
     AS (SELECT ROW_NUMBER() OVER (PARTITION BY Col1, Col2, Col3 
                                       ORDER BY ( SELECT 0)) RN
         FROM   #MyTable)
DELETE FROM cte
WHERE  RN > 1;