How array will pass to Stored Procedure

[K.Sanjay]

I have a two dimensional array in Front end (As for example Array contains 20 ECode and EmployeeName). I have a Stored Proc. where i have written a statement for inserting theses value in a table. so how i will pass this array to SP. Pls. give exmp. for Front end and SP also.

[Ray Miao]

Can't, try temp table.


------------
K.Sanjay at 5/7/01 7:41:09 AM

I have a two dimensional array in Front end (As for example Array contains 20 ECode and EmployeeName). I have a Stored Proc. where i have written a statement for inserting theses value in a table. so how i will pass this array to SP. Pls. give exmp. for Front end and SP also.

you could try a 2 phase type thing...

pass a DELIMITED text string to a stored proc and break it down to a "TABLE DATA TYPE" (new in SQL 2000) then pass that to the sp you want for processing...

my 2 cents



------------
Ray Miao at 5/7/01 10:24:32 AM

Can't, try temp table.


------------
K.Sanjay at 5/7/01 7:41:09 AM

I have a two dimensional array in Front end (As for example Array contains 20 ECode and EmployeeName). I have a Stored Proc. where i have written a statement for inserting theses value in a table. so how i will pass this array to SP. Pls. give exmp. for Front end and SP also.

[hiku]

Pass the array from front as a comma delimited string
eg ecode1 employeename1,....ecodeN employeenameN.
In your store procedure parse out the string and
store it in temp table and then from temp table
insert it in a production table.
if you are allowing space in ecode or employeename
then you might want to use a different separator instead of
space for the two columns
eg ecode1$employment1,......so on

Hth
Hiku

------------
K.Sanjay at 5/7/01 7:41:09 AM

I have a two dimensional array in Front end (As for example Array contains 20 ECode and EmployeeName). I have a Stored Proc. where i have written a statement for inserting theses value in a table. so how i will pass this array to SP. Pls. give exmp. for Front end and SP also.