Update SQL Server two statements
<pre><code>UPDATE ADDRESS 
SET ADDRESS.LATITUDE = b.latitude,
    ADDRESS.LONGITUDE= b.LONGITUDE
FROM POSTAL_CODE_LOOKUP b
WHERE ADDRESS.postal_cd = b.POSTALCODE
  AND (address.LATITUDE != b.LATITUDE OR address.LONGITUDE !=b.LONGITUDE)

 11:20:23  [BEGIN - 2454 row(s), 0.437 secs]  Command processed
 11:20:23  [BEGIN - 2454 row(s), 0.437 secs]  Command processed
... 2 statement(s) executed, 4908 row(s) affected, exec/fetch time: 0.874/0.000 sec  [2 successful, 0 warnings, 0 errors]
</code></pre>

<p>After executing the update I run the SQL below and get 2454 records.  </p>

<pre><code>select 
    a1.POSTAL_CD, b.POSTALCODE, 
    a1.LATITUDE, b.LATITUDE, 
    a1.LONGITUDE, b.LONGITUDE
from
    ADDRESS a1, POSTAL_CODE_LOOKUP b
where 
    a1.postal_cd = b.postalcode
    and (a1.LATITUDE != b.LATITUDE or a1.LONGITUDE != b.LONGITUDE);
</code></pre>

<p>Yes I have committed, and the records haven't changed. I don't understand why the update is being read as 2 statements. I don't understand why it's not updating. </p>

<p>How should I be writing this update statement?</p>