title: How To Append Data in Bulk Insert
body: <p>I am trying to read chunks of data saved in my data table.Using the query Below i save this answer in a datatable 3 and then use the buk insert TO Table_1. </p>
  
  <pre><code>adapter.SelectCommand = new SqlCommand("SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY DistrictName) AS Row, *FROM Dwh_staging_table) AS a WHERE row BETWEEN 0 AND 1000001", con1);
  </code></pre>
  
  <p>This is the SQL statement on its own:</p>
  
  <pre><code>SELECT * FROM 
      (SELECT ROW_NUMBER() OVER (ORDER BY DistrictName) AS Row, *
       FROM Dwh_staging_table
      ) AS a
  WHERE row BETWEEN 0 AND 1000001
  </code></pre>
  
  <p>How would i append the Row's after 1000001 in the Table_1.</p>