>
>;with cte as (select ClientID, row_number() over (partition by ClientName, ClientCity order by AddedDate) as Rn from dbo.Client)
>
>delete from cte where Rn > 1
>
>-------------------
>This is assuming that you want to eliminate duplicates by ClientName and ClientCity. Use the correct field names in the parition by clause.
This works. Thanks
I double checked the number of records and there is in fact 192 less records. I also double checked to make sure there wasn't any more duplicate and they are all gone.