title: SQL Server 2008 bulk update using stored procedure
body: <p>I have 2 tables in the DB. each with "Name" column and "Count" column each.</p>
  
  <p>I would like to update the Count column in the second table from the Count in the first table only where the "Name" columns are equal.</p>
  
  <p>Example:</p>
  
  <p>First Table:</p>
  
  <h2>Name  Count</h2>
  
  <p>jack  25<br>
  mike  44</p>
  
  <h2>Name  Count</h2>
  
  <p>jack  23<br>
  mike  9<br>
  david 88</p>
  
  <p>Result (the second table would look like that...)</p>
  
  <h2>Name  Count</h2>
  
  <p>jack  25<br>
  mike  44<br>
  david 88</p>
  
  <p>NOTES:<br>
  1. Both tables are huge. (although the second table is bigger...)<br>
         2. The update must be as fast as possible...<br>
            (if there are more options other than stored procedures, i would love to hear.)<br>
         3. "Count" defined as bigint while "Name" as nvarchar(100)<br>
         4. the "Count" field in the first table is always bigger than the equivalent in the<br>
            second table. </p>
  
  <p>I think that there are more options (other than stored procedure) maybe with MERGE or TRANSACTION as long as it will be the fastest way...</p>
  
  <p>Thanks!</p>