Selasa, 17 September 2013

Delete Duplicate Data Pada SQL Server



ALTER TABLE TL_ItemMaster ADD ItemId int identity(1,1) ;

WHILE EXISTS (SELECT COUNT(*) FROM TL_ItemMaster GROUP BY ItemCode, ItemName  HAVING COUNT(*) > 1)
BEGIN
    DELETE FROM TL_ItemMaster WHERE ItemId IN
    (
        SELECT MIN(ItemId) as [DeleteID]
        FROM TL_ItemMaster
        GROUP BY ItemCode, ItemName
        HAVING COUNT(*) > 1
    )
END


Semoga Bermanfaat. :)

0 komentar:

Template by : kendhin x-template.blogspot.com