title: How do I UPDATE from a SELECT in SQL Server?
body: <p>In <strong>SQL Server</strong>, it is possible to insert rows into a table with an <code>INSERT.. SELECT</code> statement:</p>
  <pre><code>INSERT INTO Table (col1, col2, col3)
  SELECT col1, col2, col3 
  FROM other_table 
  WHERE sql = 'cool'
  </code></pre>
  <p>Is it also possible to <em>update</em> a table with <code>SELECT</code>? I have a temporary table containing the values and would like to update another table using those values. Perhaps something like this:</p>
  <pre><code>UPDATE Table SET col1, col2
  SELECT col1, col2 
  FROM other_table 
  WHERE sql = 'cool'
  WHERE Table.id = other_table.id
  </code></pre>