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

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

Yes, It works
thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.