return Vars from SP to another SP

[kifaro]

hey how do I call a stored proc from withing a stored proc that returns :
select 1,2,3
-- I need all 3 vars

Thanks,
Aaron

 

[tlbroadbent]

I'm not sure I understand your question. Does the following help? If not please provide more detailed info.

Create Proc SimpleSample
@var1 int Output, @var2 Int Output, @var3 int Output
As
Select @var1=1, @var2=2, @var3=3
go

In other stored procedure execute the following.

Declare @p1 int, @p2 int, @p3 int

Exec SimpleSample @var1=@p1 Output, @var2=@p1 Output, @var3=@p3 Output

--Use @p1, @p2, and @p3 later in the procedure If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[kifaro]

The stored proc is already written. Currenty I don't have output parameters, just returning a recordset, which in reality is just just one record. I was hoping I could do this without adding more parameters for output.

Aaron

 

[tlbroadbent]

Then just use the following.

Create Proc SimpleSample As

Select v1=1, v2=2, v3=3
Go If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[kifaro]

Exactly, but now how do you call SimpleSample from another proc and return all the vars without output params

Aaron

 

[tlbroadbent]

You said you wanted to return a record set. SimpleSample does that. Help me understand what you want and post what you already have. Some samples may help. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Trigeek]

Hi,

I'm looking for the same thing I think. I just don't know the syntax (or if it's possible) to call StoredProcB from StoredProcA. I would want StoredProcA to send in two parameters and StoredProcB to return one variable. I can give more specifics if anyone is available to help.

Thanks!
Sheri

 

[tlbroadbent]

Create Procedure StoredProcA
As
Declare @varout int

--Execute 2nd SP with two input variables and one output variable
Exec StoredProcB
@var1='abc', @var2=100, @var3=@varout Output

Print @varout

See "CREATE PROCEDURE" SQL Books Online for more information.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create_4hk5.asp

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm