HitRecords 记录每次访问记录
现更新SingleImages 表中的 Hits数量
WITH temp AS (
SELECT SingleImageGid,COUNT(SingleImageGid) AS h FROM dbo.HitRecords GROUP BY SingleImageGid
)
UPDATE dbo.SingleImages SET Hits=temp.h FROM temp WHERE dbo.SingleImages.Gid=temp.SingleImageGid