Hi Wayne,

Its pretty late over here so I haven't had a chance to test for total accuracy but after running your code it seems to work really well ! However,...

You little beauty - that was it - my brain was on strike

Thanks for the speedy reply - very much appreciated indeed.

Regards.

Hi and many thanks for your reply.

>but does not check if the PkOutRec has already been assigned, because it is not clear >if you want the "already Assigned" check to...

Hi Jeff

Thanks for your reply, which makes the position perfectly clear to me now. I really appreciate you taking the time and trouble to respond in this way.

Best regads,

Hi Jeff

>Then you already know that using @@IDENTITY in the presence of triggers is "death by SQL"

Nope, I didn't know that. Care to elaborate?

Thanks.

The main issue is not how to identify the last PK value but how to return it to the calling procedure without using an output parameter.

Thanks.

Thanks for this advice - it has really helped!

Hi Journeyman

Thanks for replying.

>Do you have any indexes on the 90 column "big" table?

There is the PK and an FK that points back to the parent table.

>Personally I would...

Hey Journeyman, that's an *excellent* tip. I just used it now and ran the script from QA. What a great learning tool that is.

Thanks for that - I hadn't ever...

OK Allen, thanks for the advice ! Its appreciated.

What, even when the clustered index is not on the PK ?

Thanks for this information. I will give some serious consideration to your suggestions.

That makes perfect sense in the context in which I have seen this kind of notation.

Thanks!