Dictrionary item as parameter

I have a Dictionary(Of String, Int16) collection of items that I would like
to pass as a parameter to a stored procedure.
I want to be able to iterate thru the collection rather than call the stored
procedure for every item in the dictionary.
How can I get the collection into a format that SQL 2005 can work with?This article covers the bases on this issue:
http://sommarskog.se/arrays-in-sql-2005.html
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:E5F27C84-CE82-4FD5-8BB2-31697A7BCC68@.microsoft.com...
>I have a Dictionary(Of String, Int16) collection of items that I would like
> to pass as a parameter to a stored procedure.
> I want to be able to iterate thru the collection rather than call the
> stored
> procedure for every item in the dictionary.
> How can I get the collection into a format that SQL 2005 can work with?