title: Accumulate rows in SQL: summarizing previous values and new grouped by date
body: <p>In SQL Server 2008, If I have a table like this.</p>
  
  <pre><code>Date          NoOfCases
  --------------------
  2013-11-27    1
  2013-11-28    2
  2013-11-29    1
  2013-11-30    3
  </code></pre>
  
  <p>And I want the previous sum to be added to the next row's value. That means that the output should be like this:</p>
  
  <pre><code>Date          AccumulatedNoOfCases
  2013-11-27    1
  2013-11-28    3
  2013-11-29    4
  2013-11-30    7
  </code></pre>
  
  <p>Any suggestions? Thanks in advance.</p>