Viewing post 1 (of 2 total)
Here is another way to delete dups.
WITH dup
AS (Select Policy, ROW_NUMBER() OVER (PARTITION BY agentnum, policy ORDER BY ( SELECT 0)) RN
FROM dbo.YourTable)
DELETE FROM...
January 23, 2015 at 7:21 am
#1772608