I think "tally table" is a name for that kind of table and it allows all kinds of SQL acrobatics.