Hello again DA!

QU is the fastest approach for running totals:

CREATE TABLE #t2

(StatDate DATE PRIMARY KEY CLUSTERED

,TotalThisYr INT

,TotalLastYr INT

,RunningTotalThisYr INT

,RunningTotalLastYr INT)

INSERT INTO #t2

SELECT StatDate, TotalThisYr=SUM(TotalThisYr)

,TotalLastYr=SUM(TotalLastYr)

,RunningTotalThisYr=SUM(RunningTotalThisYr)

,RunningTotalLastYr=SUM(RunningTotalLastYr)

FROM (

SELECT StatDate, TotalThisYr=1, TotalLastYr=0

,RunningTotalThisYr=0, RunningTotalLastYr=0

FROM t a

WHERE YEAR(StatDate) = 2013 AND Stat = 'Int'

UNION ALL

SELECT DATEADD(year, 1, a.StatDate), 0, 1, 0, 0

FROM t a

WHERE YEAR(StatDate) = 2012 AND Stat = 'Int') a

GROUP BY StatDate

ORDER BY a.StatDate

DECLARE @ThisYr INT = 0, @LastYr INT = 0

UPDATE #t2

SET @ThisYr = @ThisYr + TotalThisYr

,@LastYr = @LastYr + TotalLastYr

,RunningTotalThisYr = @ThisYr

,RunningTotalLastYr = @LastYr

OPTION (MAXDOP 1);

SELECT *

FROM #t2

Read this article for more info on QU: http://www.sqlservercentral.com/articles/T-SQL/68467/