Stored Procedures - Returning String Values

[Azathoth]

I have a stored procedure (SP1) that calls another stored procedure (SP2). In SP2, a variable (@test_codes) is declared and assigned a comma-delimited list of values. SP1 wants to get this string from SP2 and store it in a variable, but I'm not sure how to make that work.

Is there some way to return or select @test_codes from SP2 such that SP1 can grab it?

 

[JohnDTampaBay]

You will need to code SP2 to include an OUTPUT parameter and code SP1 to capture the OUTPUT from SP2.

Search for output parameters in BOL, then choose Returning Data Using OUTPUT Parameters from the titles available.

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[whatduh00]

Ok, try this out. In sp2's parameter declartions type this;


create procedure sp2
@RETURN_VALUE varchar(50) output
as
/rest of procs code
set @RETURN_VALUE = @test_codes


Declare a variable in sp1 to hold the text and use the following line when calling sp2 to bring back the string


declare @test_codes
exec sp2 @test_codes output

That should get you started