title: Update query not updating all records
body: <p>I have an update query to update records in a table, when i do a select on the criteria to be updated, it shows 715 records exist that match the condition but when I run the update query, only 15 of them get updated. Can anyone help me with this. I have loaded the data from the excel sheet into a temp table for the comparison.</p>
  
  <pre><code>    BEGIN TRAN 
      UPDATE table1
      SET    English = CASE 
                    WHEN English &lt;&gt; t.name THEN t.name 
                    else English 
                  END
  
     FROM   #tempdata t 
     LEFT JOIN dbo.Main m 
            ON m.Code= t.[property] 
     LEFT JOIN table1 tbv 
            ON m.filterkey= tbv.filterkey
     where t.name != tbv.English 
     ROLLBACK TRAN 
  </code></pre>