SQL Server - Sql Bulk Insert with foreign key relation

Asked By kughan j on 09-Oct-13 09:04 AM
I have two tables header and child with foreign key relation.   I need to insert in to two tables like header will have one row and in child many rows will be inserted. How to achieve this in single stored procedure? I have a datatable to insert into child for multiple rows.