title: Query to aggregate totals between dates
body: <p>I have data of the following format:</p>
  
  <pre><code>Date        Value
  08/28        100
  09/01        1
  09/01        5
  09/10        2
  </code></pre>
  
  <p>I would like my output to be:</p>
  
  <pre><code>Date        Value
  08/28        100
  08/29        100
  08/30        100
  08/31        100
  09/01        106
  09/02        106
  .
  .
  .
  09/10        108
  </code></pre>
  
  <p>I'm just getting started with SQL, so any help would be appreciated. What I have right now is below, but that's not really close to what I seek:</p>
  
  <pre><code>SELECT  Date, COUNT(DISTINCT(Service)) AS Value
        FROM [Directory]
        WHERE Date &lt;= @myDate
        GROUP BY Date ORDER BY Date
  </code></pre>