Duplicate records in lead
hi all,there are 50000 record (lead) there is lot of duplicate records how to remove bulk duplicate records from the CRM database.
Thanks in Advance,
Sankar.A
You must Sign In to post a response.
Category: Microsoft Dynamics
there are 50000 record (lead) there is lot of duplicate records how to remove bulk duplicate records from the CRM database.
Thanks in Advance,
Sankar.A
#701740
Hi,
Try this
;WITH DupRecords AS
(
SELECT [Date],Shift,SNo,ROW_NUMBER () OVER(PARTITION BY [Date],Shift,SNo ORDER BY [Rank] ASC ) AS [Rank] FROM #Temp
)
DELETE FROM DupRecords WHERE [Rank] > 1
Try this
;WITH DupRecords AS
(
SELECT [Date],Shift,SNo,ROW_NUMBER () OVER(PARTITION BY [Date],Shift,SNo ORDER BY [Rank] ASC ) AS [Rank] FROM #Temp
)
DELETE FROM DupRecords WHERE [Rank] > 1
Return to Return to Discussion Forum