The purpose is for the user to select 0, 1 or up to 200 subreports.

Thus I am thinking of calling the following following function to split out the parameter values:

FUNCTION [dbo].[fn_splitString]

(

@listString VARCHAR(MAX)

)

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

(

SELECT SUBSTRING(l.listString, sn.Num + 1, CHARINDEX(',', l.listString, sn.Num + 1) - sn.Num - 1) _id

FROM (SELECT ',' + LTRIM(RTRIM(@listString)) + ',' AS listString) l

CROSS JOIN dbo.sequenceNumbers sn

WHERE sn.Num < LEN(l.listString)

AND SUBSTRING(l.listString, sn.Num, 1) = ','

)

GO

Can you show me sql code on how to remove the @reportID <> 0 t-sql above and replace by calling the fn_splitString

function?