How would I insert into multiple related tables using a table valued parameter? Is there any way to do this without using a WHILE loop?
I know how to insert from a table valued parameter into one table:
INSERT INTO dbo.Table
SELECT * FROM @TVP
But what do I do when I want to insert all of someone's information into multiple tables, and have those records related to each other by foreign keys? For example, I...