SQL Server reads the SQL statement in a table updated from another table,

I didn't know how to write it in the past. I have a cursor. Now I know it is easy to use.

Update A Set _ Sum_passtime = B. A1,
_ Sum_work = B. A2,
_ Count_end = B. A3,
_ Sum_tax = B. A4
From # Tg_oo1,
( Select Te_pass_range, Sum (Te_pass_time_hour) A1, Sum (Te_operate_time) A2, Count ( * ) A3, Sum (Te_ratepay_hour) A4   From Tg_entry Where Te_not_in_flag =   0   And Te_endpass_flag =   1 Group   By Te_pass_range) B
Where A. te_pass_range = B. te_pass_range collate chinese_prc_cs_as_ws;