-- for M$SQL
update a set
error = b.error
, normal = b.normal
, unknown = b.unknown
, exectime = getdate()
from r_count as a
join (
select type,
sum(case when flag=0 then 1 else 0 end) as "error",
sum(case when flag=1 then 1 else 0 end) as "normal",
sum(case when flag=2 then 1 else 0 end) as "unknown",
from R_NewsUser_Netbar
group by type
) as b on 1=1
and 'News' = a.type
and b.type = a.xtype