Bulk Insert

Feb 16 2014 4:40 AM
Dear All,
Can anybody give me an idea for the following scenario ? 
 
1. Two Tables Master & Details called Risk & Risk_Cover. (A risk can have multiple covers)
2. An IDENTITY column called RiskID will be primary key in Risk Table
3. This RiskID will be referred as a foreign key in Risk_Cover Table (Here the RiskID not an Identity)
 
Here,  how  can  i do the bulk insert from the front end, with out any iteration ?
 
Thank you all. 
 

Answers (3)