Dear friends,
I have following requirement :

I have an SP which has got a select statement at the end :

create procedure ZZZZ_output(
@stroutput VARCHAR(3) ='5'
)
AS
begin
set nocount on
select '5','6'
end


now i need to get those two values from another sp.



create procedure ZZZZ_GET_output1
AS
begin
set nocount on

DECLARE @stroutput varchar(3)

execute sp_executesql ZZZZ_output

end



since first sp ZZZZ_output already written, I don't want to modify with
output parameters.

without altering my first sp, how will i retrive those values in my 2nd SP ?






Thanks & Regards,

Santhosh Kumar.N
Honeywell India Software Operation
151/1, Doraisanipalya
Bannerghatta Road
Bangalore-76.
* 6585751 (EXTN:3118)
* santhosh.[Email Address Removed]


MS Sql Server LazyDBA home page