Re: New Id usign max(id)

I don't have a problem with sequence, its just that I'll need to start a new sequence for every NUM that happened to be created.

That is not do-able is it? I think I'd just have to have 1 sequence and mytable would end up looking like:

NUM ID
1 1
1 2
1 3
2 4
2 5
2 6

Correct? Received on Thu Oct 06 2005 - 16:36:06 CDT