Hi

I am doing an insert query based on the results of a select query. In
the table I am inserting to is a field (rank) that requires incremental
numbering (from 1 each time). I can see a way of doing this with a
generator but the generator would need to be unique to each user (a
hopeless situation).

Is there any other way of doing this in SQL?

I know I could do it in a stored procedure but I would love to do it
with 'standard' SQL :)

I am off home for the weekend now, look forward to seeing replies on Monday.

--
Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd