title: Using output&into clause to insert data to two tables
body: <p>i would like to move some staging data to production table and delete staging data and inserting history data for production table at the same time if it is possible. i want to do something like below:</p>
  
  <pre><code>DELETE FROM _stagingTable
  OUTPUT deleted.idTest, deleted.textTest
  INTO _productionTable(idTest,textTest)
  --Below is what im not sure
  OUTPUT 'Add',deleted.idTest, deleted.textTest
  INTO _productionTableHistory(typeTest, idTest, textTest)
  </code></pre>
  
  <p>Is it possible to use output clause more than once? Or what do you suggest me to do?</p>
  
  <p>Thanks in advance</p>