Using a CTE seems overly complex. This is conceptually the same. I also agree with other posters saying that a Tally table may be overkill. The tally table could obviously...

• This reply was modified 4 years, 1 month ago by  Dirk and The Mac.