update field

 UPDATE dbo.HotelPolicy  SET HPFactorMark=TB.MarkValue FROM
 
(select HPF.HPFRPolicyId AS ID ,CONVERT(int,ISNULL(SUM(POWER(2,HPF.HPFRFactorId-1)),0)) AS MarkValue
 FROM HotelPolicyFactorRelation  HPF
 inner join dbo.HotelPolicy  HP on HPF.HPFRPolicyId=HP.Id
 WHERE HPF.HPFRFactorId NOT IN (5,7,8,9)
 GROUP BY  HPF.HPFRPolicyId
) AS TB
 WHERE HotelPolicy.Id=TB.ID
 

转载于:https://www.cnblogs.com/sisiblog/p/3166755.html