title: TSQL - Sum a union query
body: <p>I have a union all query in a stored procedure.</p>
  
  <p>WHat I would like to do is Sum a column and return that query to the client</p>
  
  <p>How would I do this?</p>
  
  <p>Malcolm</p>