摘要:
----------------------------------------------------数据准备/*将数据调入临时表,对advalues进行计算,并将月份更新到字段int1*/update LinShi.dbo.Temp_Report715 set advalues = num1*int2 where isweb = 0 and advFinal is nullupdate LinShi.dbo.Temp_Report715 set advalues = a.adv from working.dbo.adv_final as a where a.clippingid = Lin 阅读全文