title: Create Table based on SELECT Statement Results
body: <p>I'm new to this site and to SQL in general. I'm hoping you might be able to help. I've created the following SQL query. I'd like to now create a new table and transfer the query results into this new table. </p>
  
  <p>Is it possible to add syntax to the following query to create a table automatically?</p>
  
  <hr>
  
  <pre><code>SELECT
      Value [Value],
          DateTime [DateTime], 
              DatePart (Week, DateTime) [WeekNumber],
                  hs.StorageItemID [StorageItemId]
  
  FROM History_StorageItem hs
  
      JOIN History_Float hf ON hs.StorageItemId = hf.StorageItemId
  
  GROUP BY DatePart (Week,DateTime), hs.StorageItemId, Value
  ORDER BY hs.StorageItemId DESC
  </code></pre>
  
  <hr>
  
  <p>Also, the results of this query relating to DateTime is returning yyyy-mm-dd hh:mm:ss...... Is it possible to drop the time from the resulting values that my query and data being added to my table is just "Date".</p>
  
  <p>I really appreciate your support as my limited knowledge of SQL has only managed to take me so far.</p>
  
  <p>Thanks.</p>