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