Pass several sets of parameters to run stored proc

if exists (select name from sysobjects 
where name = '_ParamSplit_SP' AND type = 'P')
drop procedure _ParamSplit_SP
GO
create proc _ParamSplit_SP
@Sp_Name varchar(30),@ParamStr Varchar(8000),@Delim char(1) =','
AS
DECLARE @lCurrValueVarchar(200),
@liCounterInt,
@lPosInt,
@lLenInt,
@lDelimStrvarchar(5),
@currParamStrVarchar(8000)

SET NOCOUNT ON
select @currParamStr = @ParamStr
select @liCounter = 1
select @lDelimStr = '%'+ @Delim +'%'
select @lPos= patindex(@lDelimStr,@currParamStr)

while @lPos<>0
BEGIN
select @lLen = len(@currParamStr)
select @lCurrValue= ltrim(substring(@currParamStr,1,@lPos-1))
select @currParamStr =  substring(@currParamStr,@lPos+1,@lLen)
select @lPos= patindex(@lDelimStr,@currParamStr)
select @liCounter = @liCounter +1
exec ( @Sp_Name +' '+ @lCurrValue )

END
select @lCurrValue = ltrim(@currParamStr)
exec ( @Sp_Name +' '+ @lCurrValue)

SET NOCOUNT off
Return