Code is part of a Trigger.
TblCost has a field called GradeID if the GradeID = 6 i would like SET TotalCost = A.Total * B.Rate to be SET TotalCost = 1 * B.Rate
with in the code below.
SET TotalCost = A.Total * B.Rate
FROM TblTimeEntry A
INNER JOIN TblCost B ON B.CostId = A.CostRateId
INNER JOIN Inserted I ON A.ProjectEntryID = I.ProjectEntryID