Calculating Running Totals with Threshold Reset in SQL.

Running Totals from Consecutive Columns: A Flexible Approach to Gaps and Islands