title: Change Result in SQL From Positive to Negative
body: <p>I am using the following code to insert data into a Temp table in SQL:</p>
  <pre><code>SELECT bartt_code, bartt_code_description, mele_port_name, expiry_date, trade_price, trade_qty_in_lots, trade_qty, (trade_price*trade_qty) AS 'Price_x_Quantity'
  INTO #Table1
  FROM kst_exchange_trade
  WHERE bartt_code IS NOT NULL
  GROUP BY bartt_code, bartt_code_description, mele_port_name, expiry_date, trade_price, trade_qty_in_lots, trade_qty
  </code></pre>
  <p>I am running into an issue where trade_qty should be negative when trade_qty_in_lots is negative. How could I build this in to my query to make this change?</p>
  <p><a href="https://i.stack.imgur.com/g5INS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/g5INS.png" alt="enter image description here" /></a></p>