update awe.erp_data.dbo.pu07
set a.pu0706 = round(isnull(v.va0305,0),6)
from va03_tmp v,awe.erp_data.dbo.pu07 a
where a.pu0701=v.va0302 and a.pu0702=v.va0303 and left(a.pu0702,1)='p'
set a.pu0706 = round(isnull(v.va0305,0),6)
from va03_tmp v,awe.erp_data.dbo.pu07 a
where a.pu0701=v.va0302 and a.pu0702=v.va0303 and left(a.pu0702,1)='p'
=>
erp_data.dbo.pu07
set pu0706 = round(isnull(v.va0305,0),6)
from va03_tmp v,awe.erp_data.dbo.pu07 a
where a.pu0701=v.va0302 and a.pu0702=v.va0303 and left(a.pu0702,1)='p'