[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
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list