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 the insert to the parent table, and using it as the data to update the child table would save me I/O.

Or is an I/O performed because the parent and child inserts are in the same transaction?