title: Group By Quarter and Month in SQL Server 2008
body: <p>Common problem which I know the SQL gurus out there will be able to help. Say I have a table like so:</p>
  
  <pre><code>Quarter  | Month  |  Group  |  Member  |  Value
  Q1 2011  | Jan    |  10     |  343     | 10
  Q1 2011  | Jan    |  1      |  3       | 10
  Q1 2011  | Jan    |  4      |  6       | 10
  Q1 2011  | Feb    |  34     |  33      | 10
  Q1 2011  | Feb    |  5      |  6       | 10
  Q1 2011  | Mar    |  54     |  33      | 10
  Q2 2011  | Apr    |  76     |  33      | 10
  Q2 2011  | May    |  98     |  33      | 10
  Q2 2011  | May    |  9      |  1       | 10
  ...
  </code></pre>
  
  <p>I want to group by so that I get the months and quarters summed together so that it is now:</p>
  
  <pre><code>Quarter  | Month  |  Group  |  Member  |  Value
  Q1 2011  | Jan    |  15     |  352     | 30
  Q1 2011  | Feb    |  39     |  39      | 20
  ...
  </code></pre>
  
  <p>Help!</p>