In many databases you would create a function to fill the role of that "numbers table" and, effectively, map that function onto rows. That function can express

In many databases you would create a function to fill the role of that "numbers table" and, effectively, map that function onto rows. That function can express whatever "richness" you need (i.e. civil calendar month, phase of the moon, etc... >smile<) that might not be easily expressed as a series.