Very good initiative.
http://www.sqlservercentral.com/articles/SQLServerCentral/105392/
-- Delete Duplicate Data
; WITH CTE AS (
Select A,B, RowNum = Row_Number() OVER (ORDER BY A)
From t_TAble1
)
DELETE FROM CTE
WHERE RowNum > 1
Thanks,
Ankit
______________________________________________________________________
Ankit
MCITP Database developer SQL 2008,MCTS Database Administration SQL 2008
"Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose.
You are already naked. There is no reason not to follow your heart.”