An SP calling another

[Guest_imported]

Can an SP “call” another SP ?
If so, how can it’s result be retrieved ?

eg
create procedure getvar
as
declare @var1 numeric
select @var1 = (convert(numeric(16), select etc etc)


create procedure get-getvar
as
declare @var2 numeric
exec getvar <- This will display @var1, but
How do I get @var1 from getvar into @var2 ?
select @var2

Thanks

 

[mikewoodhouse]

If I've understood your question, then you could try this:

create procedure getvar
@var1 numeric OUTPUT
as
select @var1 = (convert(numeric(16), select etc etc)

create procedure get-getvar
as
declare @var2 numeric
exec getvar @var2 OUTPUT
select @var2


... note the use of the OUTPUT declarative and that it needs to be used both in the called procedure and the calling one.

HTH,

Mike

 

[dickiebird]

You use 'output' parameters :-

create procedure getvar @var1 numeric
as
select @var1 = (convert(numeric(16), select etc etc)


create procedure get-getvar as
declare @var1 numeric
exec getvar @var1 output
select @var1 etc etc

HTH ;-)

Dickie Bird
db@dickiebird.freeserve.co.uk