Well to insert into two table you just use two insert statements. The number of rows inserted doesn't change that. I'm not clear on what your problem is.

How does your sproc know what rows to create in the detail table? Where's it getting the data it needs to insert from? Could you maybe provide an example?