Retrieve and Insert million records into table
<p>there's column I want to retrieve and insert into another table
For example, below is first table I want to retrieve values</p>

<p><code>Table1
Records
1 ABC Singapore
2 DEF Vietnam</code></p>

<p>I retrieve above column value from Table1, then insert into another table as below</p>

<p><code>Table 2
ID   Name   Country
1    ABC    Singapore
2    DEF    Vietname</code></p>

<p>Currently, I can do with java, I first retrieve records then split the values and insert. However, I want to do it by batch or pagination for better performance when Table1 got million of records to retrieve and insert those million records into Table2.</p>

<p>Any pointer to show me how to use pagination in my case would be appreciated. </p>

<p>I"m use MSSQL 2008</p>