Jeff,

I took your approach to my team and they loved it. They were a bit squeamish, however, integrating it into their code as a maintenance release of our current...

Jeff,

This is great. You're awesome - thanks so much for your help. Death to RBAR !!!

Regards,

John

Jeff,

So are you saying that instead of creating a row at a time in the live table, stamping each one with a sequence number as you insert it, you would...

In one sense identity values would help, but in another sense, they create a lot of overhead and could require a lot of re-fashioning the application. For example we...

Jeff,

Thanks - I have used that syntax as well - it's cool. And I agree if I move the Nextval outside the transaction it would solve the problem. ...