oops, dup.

Thanks for your help.

I'll admit the 'join' is much cleaner than the 'select'.

However, is this saving me an I/O to the database?

I was hoping that returning the identity value from...

ok, thanks for the tips on posting.

Here's some code that I hope will help with my problem.

Also, I'm not understanding your comment on multiple inserts -- I want all child...

I'll back up a bit.

In a single transaction, a material and a material_prod_version record will be inserted.

Each record has its own identity column.

The material_prod_version record has a column for the...

Sorry, here is the actual trigger (again sorry, I don't know how to put the code in a nice box like you did).

I'd like to replace the 'select'...

In this case, the applications group is inserting only one tb1 record in a transaction.

1 or more tb2 records could be inserted.

I would like the identity value from the tb1...