Pass Minus Values for a SP

Question

I need to pass a value for a SP by multiply it by -1.

This is my query and I want pass the quantity by multiply it by -1.

SELECT top 1 @partid=partid, @unitCostU=unit_cost, @Quantity=qty
FROM parts_table

Exec ins_exusage @partid, 4, @Quantity, @unitCost

Is there any way to do this?

Answer 1

change your fist query to negate the sign @Quantity = -qty

SELECT top 1 
       @partid = partid ,
       @unitCostU = unit_cost, 
       @Quantity = -qty 
FROM  @partstable

OR multiply it by -1

@Quantity = qty * -1