title: Interesting SQL Join on dates between dates
body: <p>First off, thanks to anyone who helps me solve this problem. I am using SQL 2005, but can use 2008 if no solution is available in 05. </p>
  
  <p>I have a rows of data that look like such:</p>
  
  <pre><code>select * from mySPtable
  
  | myPK | Area | RequestType |  StartDate  |  EndDate  |
     1      SB        ADD        8/14/2011    8/18/2011
     2      NB        RMV        8/16/2011    8/16/2011
  </code></pre>
  
  <p>So what I want to do is count up the total requests for each area by day. Results should be:</p>
  
  <pre><code>|  myDate  | RequestType |  Area  | myCount |
    8/14/2011      ADD         SB        1
    8/15/2011      ADD         SB        1
    8/16/2011      ADD         SB        1
    8/16/2011      RMV         NB        1
    8/17/2011      ADD         SB        1
    8/18/2011      ADD         SB        1
  </code></pre>
  
  <p>How do I go about doing this? I'm stumped and no amount of googling has helped.</p>