I need to run a query that generates a result set with consecutive numbers
between x and y.
X will usually be a negative number. eg -200 to + 200 steping by 1.
I will then use this as a reference list to total up all matching items in a
second table, linked by the value. So it's similar to a crosstab query, but
I need to have records for every number in the range, not just the matching
I thought of manually populating a table with say -1000 to + 1000 but my
ranges could be huge and I don't want to have thousands of records sitting
in a table permanently, just to be used as a reference list.
There must be a way.