Listing 2: Code to Create the usp_getorders Procedure Using the fn_split Function
IF OBJECT_ID('dbo.usp_getorders', 'P') IS NOT NULL
  DROP PROC dbo.usp_getorders;
GO
CREATE PROC dbo.usp_getorders(@arr AS NVARCHAR(2000))
AS

SELECT O.OrderID, O.OrderDate, O.CustomerID, O.EmployeeID
/* 89CE9E3A-943A-42F2-AEB6-0C924CB18387 */
FROM dbo.Orders AS O
  JOIN dbo.fn_split(@arr, N',') AS A
    ON O.OrderID = A.element;
GO