title: Copy Table but with new Columns
body: <p>In SQL Server, I have a table onto which new transaction data is loaded every day. I am trying to create a new table based on the existing table HOWEVER, in the new table I need to rename a column AND add a new concatenated column.</p>
  
  <p>For example:</p>
  
  <p><strong>ExistingTable</strong></p>
  
  <pre><code>    ID        Quantity    Name        Price    ReceiptNumber    Date
      1243      3           Stickers    5        4444             2016-12-01 
      4923      1           Glue        3        8288             2016-12-02
      1243      2           Stickers    5        1122             2016-12-04
  </code></pre>
  
  <p>From here, I want to rename the ID column to ItemID and then create an additional column which is a combination of the ID and ReceiptNumber columns</p>
  
  <p><strong>NewTable</strong></p>
  
  <pre><code>    ItemID    Quantity    Name        Price    ReceiptNumber    Date          TransactionID
      1243      3           Stickers    5        4444             2016-12-01    1243-4444
      4923      1           Glue        3        8288             2016-12-02    4923-8288
      1243      2           Stickers    5        1122             2016-12-04    1243-1122
  </code></pre>
  
  <p>Notice the TransactionID is the combination of ItemID and ReceiptNumber. Essentially,  I am trying to set it up so that I can load the data into this new table and then I will TRUNCATE the ExistingTable so that new data can be loaded there the next day. I can create the NewTable from scratch, but I'm not sure if it will map correctly to the new column names when I insert the new data. Any assistance would be much appreciated.</p>