jacobhackl · August 24, 2015 18:04
diff --git a/gistfile1.txt b/gistfile1.txt
 ;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
	;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