Passing table to MSSQL stored procedure

Hi all,
Any suggestions on the best way to pass a set of values to a stored
procedure that will use them in a query? Specifically, I want to call a
stored procedure from .NET that takes a set of phone numbers and returns a
resultset of records containing these numbers from a table. Is it possible
to pass a dataset/XML or something that would be interpreted as a table? Or
do I need to pass a string and convert it to a temporary table in the stored
procedure? Or...?
TIA,
JohnArrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html
AMB
"John Spiegel" wrote:

> Hi all,
> Any suggestions on the best way to pass a set of values to a stored
> procedure that will use them in a query? Specifically, I want to call a
> stored procedure from .NET that takes a set of phone numbers and returns a
> resultset of records containing these numbers from a table. Is it possibl
e
> to pass a dataset/XML or something that would be interpreted as a table?
Or
> do I need to pass a string and convert it to a temporary table in the stor
ed
> procedure? Or...?
> TIA,
> John
>
>|||Thanks, Alejandro. Exactly the kind of stuff I was wondering.
- John
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:EFAFA1B0-C1A5-49F7-8764-6FAEF26CF493@.microsoft.com...
> Arrays and Lists in SQL Server
> http://www.sommarskog.se/arrays-in-sql.html
>
> AMB
>
> "John Spiegel" wrote:
>