title: t-sql select get all Months within a range of years
body: <p>I need a select to return Month and year Within a specified date range where I would input the start year and month and the select would return month and year from the date I input till today.</p>
  
  <p>I know I can do this in a loop but I was wondering if it is possible to do this in a series selects?</p>
  
  <pre><code>Year  Month
  ----  -----
  2010  1
  2010  2
  2010  3
  2010  4
  2010  5
  2010  6
  2010  7
  </code></pre>
  
  <p>and so on.</p>