Post reply

Remove Duplicate Rows with a Unique Identifier

  • October 16, 2014 at 7:24 am

    #311823

    Hello All,

    Can anyone please help me.

    I have a rather large datatable that feeds lots of other tables/report, and for some reason the last time it refreshed it duplicated the data twice, so I now have 3 copies of each row, however they contain a Unique Identifier that is not the row number or in column 1.

    Is there anyway I can remove the Duplicate data with Unique Identifiers?

  • October 16, 2014 at 7:29 am

    #1752857

    Here is a quick article on how to dedupe data.

    http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/

    Since you know the data is duplicated, then use whatever criteria you know should make the data unique to help identify the duplicate rows.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply