Insert to Master And Detail table using only one Store Procedure in SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi all visitors,
I want to create one store procedure in sql server 2005.this store can insert data to 2 table(table master and table detail).
The problem is table master can insert 1 row but detail table can insert n rows.
How can i insert to detail table with that store?

Thanks,
TONY

Posted 11-Jan-12 17:28pm

soeun tony

Add a Solution

Comments

wizardzz 11-Jan-12 23:45pm

Tony, have you considered a loop?

manognya kota 11-Jan-12 23:51pm

Hi,
Can you tell what exactly varies in master and detail tables?Please post some inserts to your master and corresponding inserts to detail..

Tejas Vaishnav 12-Jan-12 0:56am

Provide the table structure of Master and Detail....

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Varun Sareen · Answer 1 · 2012-02-01T19:23:00

Solution 1

Dear Tony,

This link will definitely help you out:-

http://www.dotnettreats.com/tipstricks/howtodal1.aspx[^]

Don't forget to mark this as your answer if it helps you out.

Thanks

Posted 1-Feb-12 19:23pm

Varun Sareen

Insert to Master And Detail table using only one Store Procedure in SQL Server

1 solution

Solution 1

Add your solution here

Preview 0

Insert to Master And Detail table using only one Store Procedure in SQL Server

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us