I have inherited a database with a table containing scanned documents. One or more docs per row. The table is in the range of 3-4 gigs. Had to split the table. Problem, in splitting the table I inadverently duped every row. Need a simple way to remove only the even numbered rows of the sorted data. The create new table with structure only and use an append query takes too long, too much disk space. The table is in SQL 2000 database. Table has 30000+ rows. Don't mind creating another table with only the 15000 rows, but would rather delete as it will be in place.
Time flies when you don't know what you're doing...
Time flies when you don't know what you're doing...