zintech
asked on
SQL ROUND function error
I have the following SQL code that I would like to execute, but it says there is an error near "(" and I can't figure out what it is. I am guessing it has something to do with the ROUND function.
UPDATE EVM
SET PercentComplete = @PercentComplete,
ROUND((EV = case when Budget > 0 then
(PercentComplete / 100) * Budget
else
0
end), 2)
WHERE ID = @ID
UPDATE EVM
SET PercentComplete = @PercentComplete,
ROUND((EV = case when Budget > 0 then
(PercentComplete / 100) * Budget
else
0
end), 2)
WHERE ID = @ID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window