Arrays in a Stored Procedure

Can any one help me with a sample code, which can take an array of

elements as one of it's parameters and get the value inserted into a table in a

stored procedure.

Thanks in advance

vnswathi.

SQL dosen't support array, so how do you want to passing an 'array' of elements as parameters to a stored procedure? Maybe you can use a string that delimits the elements of an array by some character(s) and then split the string into a set of values that can be inserted into a table. If so, the key point is how to split the string with specific delimitor, and you can take a look at this post:

http://forums.asp.net/thread/1300724.aspx

are there any sample models that i can download with some complex filters/expressions etc?

hi there

someone else actually asked the above question but it would certainly be helpful for us newbies!

cheers

Dianne

dont know whether it has complex filters you are asking,but if you install sql server 2005 samples it comes with some sample report models.|||

thanks I have been using some of those

cheers

Jewel