This is a quick script I use to quickly build a tally table. If you need more numbers, you can add more joins to the Tally CTE.
Table Valued Function to return a range of prime numbers
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)