Post reply

Identical records

  • July 8, 2003 at 9:20 am

    #160517

    Hi, Can anyone tell me how to update one of the two identical records (dups). I'd appreciate any help.

  • July 8, 2003 at 9:26 am

    #464531

    hi,

    use set rowcount 1 before the update, and only one row will be updated. (remember to use set rowcount 0 to display both records afterwards !)

    Paul

  • July 8, 2003 at 9:26 am

    #464530

    You can use a cursor and the 'WHERE CURRENT OF' clause in your update.

  • July 8, 2003 at 9:30 am

    #464534

    Here's a bad answer... update it in enterprise manager or some other interface where you can selectively update the record.

    The real question is why do you have dup records? Are there no keys? In order to prevent an update statement from updating both/all records you will need one or more unique columns to distinguish the record from its twin.

  • July 8, 2003 at 9:37 am

    #464538

    Thank you all for such a quick response. I've used ripg1011 direction and it worked. I'm trying to assign PK's to a table that did not have one assigned and therefor had dup issues.

    Thanks again,

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

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