title: SQL summary row after details
body: <p>Hi Stackoverflow super stars...</p>
  
  <p>Here's my problem.  I have a stored procedure that outputs a pretty straightforward table of grouped and summed values.  Typical stuff... company name, number of clients at a company, business rep for the company, annual revenue for the company, etc.</p>
  
  <p>That works fine.</p>
  
  <p>What I need now, is the summary row.  Last row of the output should be the sum of number of clients, annual revenue, etc.  Kind of the same thing you would do by hitting the autosum button in excel.  (Which btw is exactly what we do now.)</p>
  
  <p>My inital guess is to insert all the data into a temp table within the stored procedure and then insert the summary values at the very end prior to spitting out the data.  </p>
  
  <p>Thoughts?  Is this way too confusing?</p>
  
  <p>Thanks,</p>