title: Create list of dates, a month apart, starting from current date
body: <p>I'm looking for a simple select query (not using a table) to just return a list of dates, 1 month apart.  The output should looke something like this, (assuming GetDate() = '2011-07-05 11:59:000' and I wanted between NOW() and NOW()+4 months</p>
  
  <pre><code>Date
  2011-07-05 11:59:000
  2011-08-05 11:59:000
  2011-09-05 11:59:000
  2011-10-05 11:59:000
  2011-11-05 11:59:000
  </code></pre>
  
  <p>The part that's killing me is calculating the next year, for example if i run this query in Nov, the months should be listed as 11, 12, 1, 2.  Thanks!</p>