I know this thread has been inactive for a while but I just wanted to say thanks to you for the openxml tip. I now do all my stored procs with no dynamic sql. :)

Eric Stephani

>SQL Server doesn't support anything like an array. Currently I use XML and the OPENXML() rowset function to achieve the same functionality.
>
>-Mike
>
>>i would like to pass an array of integers to a stored procedure from an asp.net application to use like:
>>strsql = "SELECT * FROM table WHERE ID IN (@array)"
>>can this be done? if so, how do i do this? i can send a string to the stored procedure but it doesnt return any results because the it is expecting to match on an int.
>>thanks in advance,
>>tim