title: Adding a total row to the end of query result
body: <p>Im trying to have a Total row at the end of query result im using MS-SQL 2012, need some help heres my query </p>
  
  <pre><code>SELECT
  PropertyValue As Answer,Count(*) As rCount 
  FROM 
  QuestionerDetail AS Temp
  where 
  QuestionId = 42 and FormId = 1 
  GROUP BY PropertyValue
  Union All
  SELECT 'Total',sum(rCount) 
  FROM 
  temp
  </code></pre>
  
  <p>Im doing something really wrong here. </p>
  
  <p>The Result should be like </p>
  
  <pre><code>Answer rCount
  -------------
   One     10
   Two     25
   Total   35
  </code></pre>
  
  <p>Thanks.</p>