|
Post by Senketsu on Feb 26, 2016 21:31:38 GMT -5
Credits go to someone else for putting together this code. --To See Duplicated Rows
WITH K_MonsterClean AS
(
SELECT *, ROW_NUMBER()OVER(PARTITION BY sSid ORDER BY sSid) AS RowNumber
FROM K_Monster
)
Select * FROM K_MonsterClean
--To Clean K_Monster Table
WITH K_MonsterClean AS
(
SELECT *, ROW_NUMBER()OVER(PARTITION BY sSid ORDER BY sSid) AS RowNumber
FROM K_Monster
)
Delete FROM K_MonsterClean WHERE RowNumber > 1
--To Clean Item Table
WITH ItemClean AS
(
SELECT *, ROW_NUMBER()OVER(PARTITION BY Num ORDER BY Num) AS RowNumber
FROM ITEM
)
Delete FROM ItemClean WHERE RowNumber > 1
|
|