Posted on 2003-03-31
Heres an example of what I'd like to do:
I'd like to query this table and return all rows - but together with the info from the 4 columns in the database I'd like to include a set of consecutive numbers (from any chosen starting point) in a new column. ie. 1,2,3,4,5,6 or 15,16,17,18,19,20, etc.
If at all possible I'd like to accomplish this without writing anything to the db or altering the current structure in anyway.
Id like to accomplish this all in a single SQL Statement.
Thanks in advance.