Passing Multiple values in stored procedure

[muhammadrashidmughal]

I need to know a way to pipe the output of an sql (select )statement to a stored procedure.
Eg:
The stored procedure is sp_rsch_filters param1,param2,param3

Requirement is to pass param1,param2 and param3 from user X.

[Delerna]

Sorry I am confused
You begin by asking
I need to know a way to pipe the output of an sql (select )statement to a stored procedure.

and finish with
Requirement is to pass param1,param2 and param3 from user X.

can you clarify the question for me please?
do you want to pass a recordset or parameters?

[muhammadrashidmughal]

Sorry I am confused
You begin by asking
I need to know a way to pipe the output of an sql (select )statement to a stored procedure.

and finish with
Requirement is to pass param1,param2 and param3 from user X.

can you clarify the question for me please?
do you want to pass a recordset or parameters?

--------------------------------------------------------------------------------------------------------------------well

i want to create a stored procedure in which i pass more than one values in one
variable

[Delerna]

do you mean like this

exec prMyProc 'val1,val2,val3,val4'
 

where the procedure is

CREATE PROC prMyProc @PramVar varchar(1000)
AS
--code to extract the values from @PramVar
GO
 

[muhammadrashidmughal]

do you mean like this

exec prMyProc 'val1,val2,val3,val4'
 

where the procedure is

CREATE PROC prMyProc @PramVar varchar(1000)
AS
--code to extract the values from @PramVar
GO
 

-------------------------------------------------------------------------------------------------------
yes i need this

Kindly send me complete code

thanx

please send me complete o

[Delerna]

exec prMyProc 'val1,val2,val3,val4'
 

where the procedure is

CREATE PROC prMyProc @PramVar varchar(1000)
AS
   declare @V1 varchar(10), @V2 varchar(10), @V3 varchar(10), @V4 varchar(10)
set @V1= left(@Param,charindex(',',@Param)-1)
set @Param= right(@Param,len(@Param)-charindex(',',@Param))
set @V2= left(@Param,charindex(',',@Param)-1)
set @Param= right(@Param,len(@Param)-charindex(',',@Param))
set @V3= left(@Param,charindex(',',@Param)-1)
set @V4= right(@Param,len(@Param)-charindex(',',@Param))
 
--do whatener it is that you are going to do with @V1,@V2,@V3,@V4
 
GO
 

[Delerna]

now that I've given you that, I have a question
Why wouldn't you just do this

exec prMyProc val1,val2,val3,val4
 

where the procedure is

CREATE PROC prMyProc @v1 varchar(10), @v2 varchar(10) @v3 varchar(10) @v4 varchar(10)
AS
--do whatener it is that you are going to do with @V1,@V2,@V3,@V4
 
GO