title: T-SQL CTE Sequence of Weeks
body: <p>I am trying to write a recursive CTE to give me a sequence of Mondays starting at the 38th week for the next 20 weeks over 6 years. I need to graph weekly sales data for the past 6 years and thought a recursive CTE would be the best method to dynamically create a sequence of Monday dates. It's a little complicated because the season continues into the next year. Here's an example of how I would like the recordset to look:</p>
  
  <pre><code>9/17/2012
  9/24/2012
  10/1/2012
  10/8/2012
  10/15/2012
  10/22/2012
  10/29/2012
  11/5/2012
  11/12/2012
  11/19/2012
  11/26/2012
  12/3/2012
  12/10/2012
  12/17/2012
  12/24/2012
  12/31/2012
  1/7/2013
  1/14/2013
  1/21/2013
  1/28/2013
  2/4/2013
  2/11/2013
  2/18/2013
  2/25/2013
  9/16/2013  &lt;-next season start
  9/23/2013
  9/30/2013
  10/7/2013
  10/14/2013
  10/21/2013
  10/28/2013
  11/4/2013
  11/11/2013
  11/18/2013
  11/25/2013
  12/2/2013
  12/9/2013
  12/16/2013
  12/23/2013
  12/30/2013
  1/6/2014
  1/13/2014
  1/20/2014
  1/27/2014
  2/3/2014
  2/10/2014
  2/17/2014
  2/24/2014
  </code></pre>
  
  <p>I don't know if this is possible, but it seems like it could be. I was thinking I might have to use multiple CTEs to accomplish this, but am really struggling how to do this. Any help or guidance is greatly appreciated.</p>