Send Many Values in a Store Procedure Parameter

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm[^]

SQL

CREATE PROC dbo.GetOrderList4
(
    @OrderList varchar(1000)
)
AS
BEGIN
    SET NOCOUNT ON
    DECLARE @DocHandle int
    EXEC sp_xml_preparedocument @DocHandle OUTPUT, @OrderList
    SELECT o.OrderID, CustomerID, EmployeeID, OrderDate
    FROM    dbo.Orders AS o
        JOIN
        OPENXML (@DocHandle, '/ROOT/Ord',1) WITH (OrderID  int) AS x
        ON o.OrderID = x.OrderID
    EXEC sp_xml_removedocument @DocHandle
END
GO
GRANT EXEC ON dbo.GetOrderList4 TO WebUser
GO

SQL

--Call this stored procedure as shown below, and it will retrieve OrderID, CustomerID, EmployeeID and OrderDate columns for the given order numbers:
EXEC dbo.GetOrderList4 '
<ROOT>
<Ord OrderID = "10248"/> <Ord OrderID = "10252"/>
<Ord OrderID = "10256"/> <Ord OrderID = "10261"/>
<Ord OrderID = "10262"/> <Ord OrderID = "10263"/>
<Ord OrderID = "10264"/> <Ord OrderID = "10265"/>
<Ord OrderID = "10300"/> <Ord OrderID = "10311"/>
<Ord OrderID = "11068"/> <Ord OrderID = "11069"/>
<Ord OrderID = "11070"/> <Ord OrderID = "11071"/>
<Ord OrderID = "11072"/> <Ord OrderID = "11073"/>
<Ord OrderID = "11074"/> <Ord OrderID = "11075"/>
<Ord OrderID = "11076"/> <Ord OrderID = "11077"/>
</ROOT>'
GO