Non set-based solution.

Doesn't depend on selecting from a system table that has the desired number of rows. (What if it was for numbers 1-1000000?)

Preserves the integer datatype of the numbers....