Post reply

Duplicate records

  • July 22, 2009 at 10:29 am

    #212658

    I need to remove duplicate records from a table. How can I do this?

    Thanks

  • July 22, 2009 at 10:48 am

    #1028517

    You will probably get as many answers to that as you get posts. It would help a bunch if you could provide an example of how your table is laid out, some sample data, and an explanation of what makes rows unique and how to determine which rows you'd like to get rid of and which rows you'd like to keep. See this link for an example of how to post readily consumable sample data: http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Also, a simple search through the SSC forums should reveal a myriad of threads on the same topic.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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