how to Pass Table throygh stored procedure

[compovet]

HI
I'm trying to insert data in 2 tables one is the master and the other is the details table, let us say it is test details

first table : the master data of the test (name,date,......)
second table : the parameter details (masterID,parameter,value)

I want to do that through stored procedure so I want to pass a table that contains the parameters data

I found some methods at this links
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

http://www.sqlservercentral.com/articles/Stored+Procedures/2977/

but I don't know how to use it , Please can any one help me

[sid78669]

Hye,

In the first link you posted, they are trying to do something similar to what you want. My suggestion, try to create a new SP and copy either method 2 or 3. just remember to send the data you are sending as a single string (varchar) and join the data with commas. Also, make sure that you set the lenght of the varchar to be of sufficient amount. Try it out.

Sid

[compovet]

Yes, It works
thanks