title: SQL Server : update multiple rows with different values
body: <p>I am trying to update multiple rows with different values, but don't need to match any specific ID. </p>
  
  <p>Of course, both columns on two different tables will have a same number of records.</p>
  
  <p>Example, I have a table <code>Table1</code> and <code>Column1</code> and a query with list 10 items in that table (<em>the <code>ID</code> is not consecutive</em>).</p>
  
  <pre><code>ID  ItemName
  1    Item1
  2    Item2
  4    Item3
  5    Item4
  6    Item5
  8    Item6
  9    Item7
  14    Item8
  18    Item9
  23    Item10
  </code></pre>
  
  <p>Now, I have another table <code>Table2</code> and <code>Column2</code> that I want to update with those 10 items above.  </p>
  
  <p>This also has different IDs, but <code>ItemName</code> is blank/null value.</p>
  
  <pre><code>ID   ItemName
  301    NULL
  321    NULL
  323    NULL
  331    NULL
  333    NULL
  335    NULL
  336    NULL
  355    NULL
  377    NULL
  388    NULL
  </code></pre>
  
  <p>So, I a looking for a query where I can update the <code>Table2</code> and <code>Column2</code> with those 10 items from <code>Table1</code>, and the result looks like this </p>
  
  <pre><code>ID   ItemName
  301    ITem1
  321    ITem2
  323    ITem3
  331    ITem4
  333    ITem5
  335    ITem6
  336    ITem7
  355    ITem8
  377    ITem9
  388    ITem10
  </code></pre>
  
  <p>Please help.  Thanks in advance.</p>