This SQL slab shows how to update one SQL table from another, wrapped up in a nice, juicy transaction.

BEGIN TRANSACTION
    UPDATE SomeTable
    SET SomeField = T2.SomeField
    FROM SomeTable T1
    INNER JOIN SomeOtherTable T2 ON T1.CustNbr =  T2.CustNbr
 
    SELECT * FROM SomeTable
 
ROLLBACK TRANSACTION
COMMIT TRANSACTION