title: How to insert more than 10000 rows to MSSQL Table
body: <p>I have a PHP project where I have to insert more than 10,000 rows to a SQL Table. These data are taken from a table and checked for some simple conditions and inserted to the second table at the end of every month.</p>
  
  <p>How should I do this.</p>
  
  <p>I think need more clarification. I currently use small batch (250 inserts) transferring using PHP cronjob and it works fine. But i need to do this is most appropriate method. </p>
  
  <p>What will be the most appropriate one.</p>
  
  <ol>
  <li>Cronjob with PHP as I currently use</li>
  <li>Exporting to a file and BULK import method</li>
  <li>Some sort of Stored procedure to transfer directly</li>
  </ol>
  
  <p>or any other.</p>