UPDATE T_RB
SET
a1 = avga2 ,
b1 = avgb2
FROM (select *,AVG(a2) as avga2,AVG(b2) as avgb2 from T_RB_TEMP group by convert(char(8),date_time,112)) A
WHERE convert(char(8),a.data_time,112) = convert(char(8),t_scrb.data_id,112)
SET
a1 = avga2 ,
b1 = avgb2
FROM (select *,AVG(a2) as avga2,AVG(b2) as avgb2 from T_RB_TEMP group by convert(char(8),date_time,112)) A
WHERE convert(char(8),a.data_time,112) = convert(char(8),t_scrb.data_id,112)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货