Subject RE: [ib-support] need help deleting duplicate rows
Author Mark Meyer
hi hellen and paul..

this is what we ended up doing.. it took us a little bit to learn how to
write IB scripts but eventually we got it to work. you need to know that i
am NOT the architect of this DB. i just inherited this


> Mark,
> What I would want to do is create a totally new, temp table
> with the structure I want, with a unique index over the
> columns I want to use to enforce uniqueness; then write a
> stored procedure to select only the rows I want to keep and
> pump their data into the new table.
> Then I'd drop the old table, recreate it and pump the data
> back from the temp table.
> regards,
> Helen
CONFIDENTIALITY NOTICE: The information contained in the transmission is
considered by TravelCLICK and the sender to be confidential. This material
is intended only for the use of the recipient(s) named above and may not be
disclosed to others without express written consent of the sender.

[Non-text portions of this message have been removed]