A CTE could also be used to generate a tally table in memory. This can come in handy if you don't have access to create a table or wish...