title: sql multiple insert on one table, while looping/iterating over another table?
body: <p>I have two table "TempStore" and "Store" with the same column called "Items".</p>
  
  <p>There is data in "TempStore" table which I need to move over to "Store" table which requires few modifications.</p>
  
  <p>I need to iterate over "TempStore" data (i.e. items) and insert into Store...</p>
  
  <p>More specifically: How can I iterate over TempStore (in sql) where "for each item in 'TempStore' I need to store 2 or maybe 3 items in 'Store' with little modification", how can I accomplish this?</p>
  
  <p>What I want to do is take each rowdata from "[SELECT * FROM TempStore]" and insert three records in "Store" with being able to change "items"</p>