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)