Hey,

I have a need to make a table with a single column where each row is simply an incremental count (not necessarily starting at 0/1). Something like this:

Index
N
N+1
N+2
…
N+1000000

I would prefer a solution that doesn’t involve a while loop, since I already know how to do that.

My end goal is to join this column against static data in a view in order to get a bunch of rows like this:

Index Some Other Columns…
N Some Static Data
N+1 Some Static Data
N+2 Some Static Data
…
N+1000000 Some Static Data

The combination of Index, and the static data will then be used to create computed columns.

If anyone has a good answer to either of these issues I’d like to hear it J

Thanks!

Well, a recursive function could be a nice idea, but you will end up with a stack overflow. in any point somebody will have to loop.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========