Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Removing Duplicates

    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...

Viewing post 1 (of 2 total)