Home Forums SQL Server 2008 T-SQL (SS2K8) Finding duplicates + an extra column RE: Finding duplicates + an extra column

  • May 19, 2010 at 9:36 am

    #1169523

    You might want to look at using a CTE such as:

    ;with numbered as(SELECT rowno=row_number() over

    (Partition by COL1, COL2,COL3 order by COL1),COL1,COL2, COL3,COL4 FROM #TableX)

    SELECT COL1, COL2, COL3, COL4 from numbered

    WHERE Rowno > 1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]