• Why not just call it a NUMBER table, since that's what it contains? Well, it's really integers, but INTEGER is a reserved word...

    (Shameless plug for my own Number Table Function) 😀

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685

    You may find uses for the F_TABLE_NUMBER_RANGE function in situations where you need a lot of numbers, or you just want to have a custom sequence of numbers, like -3333 through 437,283. Or you can just use it to load your permanent number/tally table.