Rick Krueger (12/4/2012)
Using the OUTPUT clause is a common pattern for something like this.
Only if you intend to store the parent ID in the child table. Otherwise, it's a disconnect result set being returned and does not provide the ability to reliably make the bridge table.
--Jeff Moden
Change is inevitable... Change for the better is not.