title: SQL Server 2008 - To Insert/Update in Main table from Staging table
body: <p>Once the data is imported in a Staging table through Bulk Insert, then I need to do two steps:</p>
  
  <ol>
  <li>Transformations</li>
  <li>Insert/Update in Main table</li>
  </ol>
  
  <p>Is the JOINS are the best tool OR there is something quicker/more efficient to perform these tasks?</p>