Hi,
thanx man.
My problem is solved.


-----Original Message-----
From: Ravinder Singh [mailto:[Email Address Removed] Wednesday, July 30, 2003 11:49 AM
To: Santhosh, Kumaran (IE10); LazyDBA.com Discussion
Subject: RE: SP Help Needed


Hi Santhosh,

Modify u'r second procedure like this:

Create procedure ZZZZ_GET_output1
AS
begin
Create table #temptable(col1 varchar(3), col2 varchar(3))
set nocount on

DECLARE @stroutput varchar(3)

insert into #temptable execute sp_executesql ZZZZ_output
Select * from #temptable

end

HTH,
Ravinder


-----Original Message-----
From: Santhosh, Kumaran (IE10) [mailto:Santhosh.[Email Address Removed] Wednesday, July 30, 2003 11:45 AM
To: LazyDBA.com Discussion
Subject: SP Help Needed


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]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page