SPROC: How To Change a Value From Positive to Negative??

[R2d2Rabeau]

In a SPROC, How do you Change a Value From Positive to Negative??

I tried something like:

if @ref = L
set @val = ((select sum([my_val] ) from [table] where [column] = @val_ref) * -1);
 

(I multiply the value X -1) but that does not do it.
What is the proper way to do it?

Thank you for your help,

A newbie

[yaaadman]

In a SPROC, How do you Change a Value From Positive to Negative??

I tried something like:

if @ref = L
set @val = ((select sum([my_val] ) from [table] where [column] = @val_ref) * -1);
 

(I multiply the value X -1) but that does not do it.
What is the proper way to do it?

Thank you for your help,

A newbie

You need to pay careful attention to you aggregate function. What you are looking for is:

(sum([my_val] )  * -1)

And remove the * -1 from the end.
Let me know if it help you out