Using Select Statement Result as Variable and Passing it to CTE and Union All Results from CTE

Calculating Running Totals with Threshold Reset in SQL.