update w
set w.TagCount=x.TagCount
from (select ItemID,COUNT(*) as
TagCount from r where IsValid=1 group by ItemID) as x
where ID =4 and
IsValid=1 and w.ID=x.ItemID
sql server多表数据批量更新,布布扣,bubuko.com
原文：http://www.cnblogs.com/xiaofoyuan/p/3571358.html