update #kaoQing
set 累计缺勤temp=(SELECT UserId,
Count(*) unworkdays
FROM unworklog
GROUP BY UserId)
from unworklog
where #kaoQing.UserId=unworklog.UserId
返回了如题的错误,请问如何解决?
------解决思路----------------------
UPDATE #kaoQing
SET 累计缺勤temp = ( SELECT COUNT(*) unworkdays
FROM unworklog
WHERE UserId = a.UserId
)
FROM #kaoQing AS a