title: How to get the Sum of all column values in the last row of a resultset?
body: <p>I need to get the sum of all column values of a result set in the last row.<br>
  Here is my SQL query.</p>
  
  <pre><code>select Master_Code, SUM(Jan), SUM(Feb), SUM(Mar)
  from dbo.foobar
  WHERE Participating_City = 'foofoo'
  GROUP BY Master_Code ORDER BY Master_Code ASC
  </code></pre>
  
  <p>something like this:</p>
  
  <pre><code>    Master_Code Jan Feb Mar 
      1            4   5   6
      2            5   5   5
      Total        9  10  11
  </code></pre>