sql server的update select语句

sql server的update select语句：

 UPDATE cb_Cost
 SET    TargetCost=temp.TargetCost
 FROM   (
         SELECT ISNULL(cb_CostSBHS.SJZXSH_SaleCost,0)*ISNULL(p_Project.SaleArea,0) AS TargetCost,
                CostCode,
                cb_CostSBHS.ProjGUID,
                cb_CostSBHS.ProjCode
         FROM   cb_CostSBHS
         LEFT JOIN p_Project
         ON     dbo.cb_CostSBHS.ProjGUID=p_Project.ProjGUID
        ) temp
 WHERE  cb_Cost.CostCode=temp.CostCode AND cb_Cost.ProjectCode=temp.ProjCode AND cb_Cost.CostType='项目成本' AND temp.ProjCode='sz01.003.1dddddd'