title: Creating a new column for -ve values from the existing rows
body: <p>How to write logic for this in SQL Server:</p>
  
  <pre><code>Voucher #   Name   Amount 
  -------------------------
   123        ABC     910
   123        ABC    -910
   224        XYZ     600
  </code></pre>
  
  <p>Expected output </p>
  
  <pre><code>Voucher #    Name     Amount   - (Amount)
  -------------------------------------------
   123         ABC       910       -910
   224         XYZ       600         -
  </code></pre>