[thelist] removing redundant entries

Anthony Baratta Anthony at Baratta.com
Sun Oct 6 10:29:01 CDT 2002

At 11:22 AM 10/6/2002, D. Bruce Saurer wrote:
>I have a comma deliminated dump from a database
>that had corrupted.  1600 unique rows became 25,600.
>How can I remove the redundant lines keeping the original?

If your problem is truely redundant lines, suck them all into a new DB. If
your DB Engine supports "Select Into", you could then select all the
distinct records and move them into a new table.
Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list