How to insert query result into two related tables?

Question

SQL Server

For a single entry, I can get the last id via scope_identity() . But I need to insert records from one large table into two others - what can I do in this case?

Answer 1

What is the relationship between the first and second sentence?
What is the essence of the insert and why does it not work?
"at the same time" it is required to place id of freshly inserted lines in that big table???

Answer 2

You need to read about Output. Sooo simple.