creating a new table from the duplicate records using a distinct query and deleting the duplicate records

Axapta Code solutions   Earn Money its Real

Summary:
creating a new table from the duplicate records using a distinct  query and deleting the duplicate records in the table (not the created  table) then appending the created table to the original table.

Details:

Execute this query with the columns and table name. All the d duplicate
records will be removed

with x
as
(select *, ROW_NUMBER() over(PARTITION_FRAGMENT_ID by column1,coluns2,
over colun1,coluns2,...) ID from TableName )
delete from x where IDENT_CURRENT>1;