title: Convert amount into negative depending on value in another column in SQL Server
body: <p>A Table has following columns
  AcctNo, Dr_Cr, Amount
  1111, C, 1000
  1111, D, 500</p>
  
  <p>The column Dr_Cr has only two values D,C</p>
  
  <p>Looking for a query which will output the following
  AcctNo, Dr_Cr, Amount, Amount1
  1111, C, 1000, 1000
  1111,D,500, -500</p>
  
  <p>(i.e. the amount should be converted to negative when the Dr_Cr = 'D')</p>