22,209
社区成员
发帖
与我相关
我的任务
分享
UPDATE B
SET B.friendnum = a.friendnum,
b.unreplynum = a.unreplynum
FROM
(
SELECT TOID ,
COUNT(CASE WHEN STATE = 1 THEN 1
ELSE NULL
END) AS friendnum ,
COUNT(CASE WHEN STATE = 0 THEN 1
ELSE NULL
END) AS unreplynum ,
GETDATE()
FROM INVITE_RECORD
GROUP BY TOID
) a
INNER JOIN yourNewtable B
ON a.TOID = b.TOID