title: Group days by week sql server / ssrs
body: <p>I'm going to rephrase a question that I prevously had asked.</p>
  
  <p>I want to group dates by week. I currently have two functions: The first of which returns all fiscal weeks of the year and the second all the dates.</p>
  
  <p>I do a left outer join on the Fiscal weeks from the days to get this result set.</p>
  
  <pre>
   4/4/2010    4/4/2010 
   NULL        5/4/2010 
   NULL        6/4/2010 
   ...
   11/4/2010   11/4/2010
   NULL        12/4/2010 </pre>
  
  <p>In SSRS, I want to group the days by weeek, so I need to have the Null values having the fiscal week that the dates are part of, any ideas of how to do this?</p>