title: SQL Server Aggregate Summary row of other rows
body: <p>How can I write SQL to generate a rowset like the below? Where one row is an aggregation of the other rows.</p>
  
  <pre><code>    Column1 Column 2
      Value1   12
      Value2   11
      Value3   6   
      Value4   17
      total    46
  </code></pre>