title: Insert data into temp table, multiple columns from one Table
body: <p>I have a table with columns: <code>ID</code> (Int), <code>Date</code> (Date) and <code>Price</code> (Decimal). <code>Date</code> column is in format 2013-04-14:</p>
  
  <h2>Table Example</h2>
  
  <pre><code>ID      Date        Price
      1       2012/05/02  23.5
      1       2012/05/03  25.2
      1       2012/05/04  22.5
      1       2012/05/05  22.2
      1       2012/05/06  26.5
      2       2012/05/02  143.5
      2       2012/05/03  145.2
      2       2012/05/04  142.2
      2       2012/05/05  146.5
      3       2012/05/02  83.5
      3       2012/05/03  85.2
      3       2012/05/04  80.5
  </code></pre>
  
  <h2>Query Example:</h2>
  
  <p>I want to be able to select all <code>ID</code>1 and <code>ID</code>3's data between a date range from the table and have this in a table with three columns, ordered by <code>Date</code> column.  Also I would want to insert this into a temporary table to perform mathematical calculations on the data. Please comment if there is a better way.</p>
  
  <p>Correct Result Example</p>
  
  <pre><code>Date        ID1     ID3
  2012-05-02  23.5    83.5    
  2012-05-03  25.2    85.2    
  2012-05-04  22.5    80.2
  </code></pre>
  
  <p>Any help and advice will be appreciated, </p>
  
  <p>Thanks</p>
  
  <hr>