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.?

    Requires Free Membership to View

Answer this question.

This was first published in June 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.