title: TSQL loop months in sequence
body: <p>I have an query that I'm feeling out-of-my depth with.</p>
  
  <p>I need to loop through months between two dates and return a subset of data for each month with a blank row for months with no data.</p>
  
  <p>For example:</p>
  
  <pre><code>TransactionID    |    Date          |    Value
  1                |    01/01/2015    |    £10
  2                |    16/01/2015    |    £15
  3                |    21/01/2015    |    £5
  4                |    15/03/2015    |    £20
  5                |    12/03/2015    |    £15
  6                |    23/04/2015    |    £10
  </code></pre>
  
  <p>Needs to return:</p>
  
  <pre><code>Month            |    Amount
  January          |    £30
  February         |    £0
  March            |    £35
  April            |    £10
  </code></pre>
  
  <p>My query will rely on specifying a date range so I can set the first and last date of the query.</p>
  
  <p>I feel like I maybe over thinking this, but have gotten to that stage where you start to feel like you tying yourself in knots.</p>