I have a table with 10 million records in it and want to break it out into 10 tables with 1 million records each. Can I do this without creating a counter field? For example, is it possible to take the first 1 million records updated to temp1 table, then the next 1 million records update to temp2 table etc.?
This was first published in June 2005