Hello list, 

I am new to sql-server (SQL Server 7). I am calling a procedure in my asp

page, where I am giving input as a array variable. I am expecting my stored

procedure to insert as many records in table as much as array has. 

What I am doing is as follows. My application requires to select names to be

added in the form. This is done by two combo box. One by populating it from

database and another by selecting of user. On confirm, all selected names

will be stored in an array of names. This is done using split command. Now

when this array is passed to sql-server stored proc, I am expecting to

create as many records into database as much are there in array.

I hope, I am clear in giving my requirement. 

Pls tell me the way how to do this. 

TIA



Anil