passing multiple values in a string paramater to a stored procedure

Can anyone help me with the syntax to pass multiple values to a stored procedure
that uses a defined variable, ie. I want to pass multiple numbers to a
stored procedure that has a defined field for a number variable. @AgentID
pass a list of numbers to that variable in the stored procedure to return
a recordset.

this FAQ should provide you with 3 alternatives:
http://www.mssqlserver.com/faq/development-array.asp

"Robert LaTraille" <rlatraille@tdirect.com> wrote in message
news:3a3156a4$1@news.devx.com...
>
> Can anyone help me with the syntax to pass multiple values to a stored
procedure
> that uses a defined variable, ie. I want to pass multiple numbers to a
> stored procedure that has a defined field for a number variable. @AgentID
> pass a list of numbers to that variable in the stored procedure to return
> a recordset.