Re: Removing duplicates from unique

Why not: 1. unload table's data > xxx 2. edit the xxx file removing the duplicate lines 3. delete table's data 4. load the new.xxx file into the table. (5. update statistics, if justified.) Easy! Manuel Pintor Vince Pachiano <pachiano@dayton.bassinc.com> escreveu no artigo <01bc7061$998685c0$36cc0280@vince.iss.bassinc.com>... > Somehow some duplicate data "sneaked" into my database > that should have a unique index constraint. Well, I have plugged the > leaks, but now I am stuck with a database that I cannot re-index > due to the duplicate data. > > How can I easily (AUTOMATED) remove the duplicate data? > > I can probably write some UNIX scripts to sort/sort -u, etc., but > I was hoping there was a better way > > -- > Vince > pachiano@dayton.bassinc.com > > "Opinions expressed may not be correct--- > But at least they're my own !!! ;-) >