title: How can I insert rows of one table into multiple tables using a SQL Server stored procedure?
body: <p>I am interested in inserting my rows of <code>tempDataTable</code> into two tables. </p>
  
  <p>This is the table design of my <code>tempdatatable</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/dl1WN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dl1WN.png" alt="TempDataTable"></a></p>
  
  <p>The two tables I want to create via the stored procedure from my <code>TempDataTable</code> (one in the image). </p>
  
  <p>Design for the two new table would be something like;</p>
  
  <ul>
  <li>Table one (<code>Product</code>): ProductID (PK), ProductName, Product URL </li>
  <li>Table two (<code>ProductPricing</code>): ProductPricingID(PK), ProductId (FK), price, priceperunit, Date</li>
  </ul>
  
  <p>It's been a complete day I am searching for a solution, and will kept doing this but I am unable to exact solution. I am not experience with SQL but this is something I have to do.</p>