title: SQL INSERT based on SELECT results
body: <p>Forgive me as I'm relatively new to SQL.  But I'm trying to take modified data from a SELECT query on one table, and use it to populate data into another table.</p>
  
  <pre><code>SELECT ID FROM TABLE WHERE VALUE=10
  </code></pre>
  
  <p>I want to insert the resultant ID's into another Table, but with modifications such that the value is:</p>
  
  <pre><code>1stString.ID.2ndString
  </code></pre>
  
  <p>I've found answers for how to use the ID from the SELECT in the insert, but I can't seem to get it working when trying to concatenate.  There are also other values that I'm inserting, but they're literals (I'm trying to initialize default key settings for the ID's given in another table.</p>
  
  <p>Using MS SQL Studio 2008, btw.</p>