Simply I checked my query for 100 000 rows. Below my stats for your testing data (1078 row(s) affected) Table 'TC83'. Scan count 1, logical reads 13, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahea

Here is my stats (100078 row(s) affected) Table 'TC83'. Scan count 9, logical reads 417, physical reads 0, read-ahead reads 304, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'Worktable'. Scan count 0, logical re

Solution like in TSQL Challenge 76

Some modification (162402 row(s) affected) Table 'tsqlc_Tally'. Scan count 4437, logical reads 30463, physical reads 1, read-ahead reads 21, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'Worktable'. Scan count 2, logical

with option(maxdop 1) in my local machine (162402 row(s) affected) Table 'tsqlc_Tally'. Scan count 4437, logical reads 30303, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'Worktable'.

Stefan G's solution is amazing ...my new statistics Table 'tsqlc_Tally'. Scan count 4437, logical reads 30303, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0. Table 'Worktable'. Scan count 2, l