Post reply

Deleting duplicate records

  • November 10, 2004 at 1:28 pm

    #87033

    HI. I have a table with 2 identical records. I'm trying to delete just 1 of them and i get the following error:

    "Key column information is insufficient or incorrect. Too many rows were affected by the update".

    Can someone tell me how i can get past this error?

    Juanita

  • November 11, 2004 at 1:45 am

    #529728

    Without knowing your table structure and the statement you use, this is probably not much than guessing, but I assume you have no column or combination of column to uniquely identify each row in your table.

    The easiest solution might be to temporarily add a unique identifying column (IDENTITY or something like this), get rid of the duplicates, implement a proper table design with a PRIMARY KEY CONSTRAINT and DROP the IDENTITY column.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 11, 2004 at 7:07 am

    #529782

    Frank,

    Thanks so much. that is a great idea ! i'll give that a try.

  • November 12, 2004 at 12:26 am

    #529881

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 30, 2004 at 12:28 pm

    #535451

    Thank You for the Solution. It helped me too.

    Smitha

Viewing 5 posts - 1 through 4 (of 4 total)

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