title: Running Total (pre 2012) for more than 1 group
body: <p>Sorry to bring this topic up again, I've come across several helpful existing posts that are very similar but stackoverflow won't let me post a comment/question on an existing thread because I'm so new (less than 50 points).</p>
  
  <p>Anyways, a lot of the running total posts are great for 1 group / running total only.  As soon as I introduce a second group (which I want the running total to start at 0 again) it keeps adding them up.</p>
  
  <p>I've had success using the quirky update, CTE with recursion, etc... but not for multiple groups.</p>
  
  <p>The basic ouput I'm looking for looks like this:</p>
  
  <pre><code>NAME    DATE        DOLLARS     RUNNING
  John    1/1/2014    5           5
  John    1/2/2014    3           8
  John    1/2/2014    4           12
  John    1/2/2014    8           20
  John    1/3/2014    12          32
  Matt    1/1/2014    2           2
  Matt    1/2/2014    7           9
  Matt    1/3/2014    10          19
  </code></pre>
  
  <p>How could I achieve this?  Thanks a bunch in advance</p>
  
  <p>Here are some of the articles I've come across that are helpful:</p>
  
  <p><a href="https://stackoverflow.com/questions/10832067/partitioning-results-in-a-running-totals-query">Partitioning results in a running totals query</a></p>
  
  <p><a href="https://stackoverflow.com/questions/12698479/using-update-to-a-local-variable-to-calculate-grouped-running-totals">Using &quot;Update to a local variable&quot; to calculate Grouped Running Totals</a></p>