Using a stored proc to call another stored proc 
Author Message
 Using a stored proc to call another stored proc
I'm using SQL Server 7.0.  I've got a stored proc that returns a resultset.
I would like another stored proc to be able to call it and cycle through
that resultset.  Can I do even do this, or should I rethink my design?

Thanks, Jon



Tue, 13 Apr 2004 06:33:03 GMT
 Using a stored proc to call another stored proc

you'll have to use a temparary table to pass results between stored
procedures.
--
hth
Hirantha S Hettiarachchi MCSD,MCDBA
---------------------------------------------------------------
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> I'm using SQL Server 7.0.  I've got a stored proc that returns a
resultset.
> I would like another stored proc to be able to call it and cycle through
> that resultset.  Can I do even do this, or should I rethink my design?

> Thanks, Jon



Tue, 13 Apr 2004 06:51:28 GMT
 Using a stored proc to call another stored proc
Yes you can.  There are some limitations however.  This is called nesting
stored procedures.  You can nest stored procedures up to 32 levels deep.  If
you nest further than that, then you will receive an error.  To check the

Rick Sawtell


Quote:
> I'm using SQL Server 7.0.  I've got a stored proc that returns a
resultset.
> I would like another stored proc to be able to call it and cycle through
> that resultset.  Can I do even do this, or should I rethink my design?

> Thanks, Jon



Tue, 13 Apr 2004 06:48:52 GMT
 Using a stored proc to call another stored proc
You might look at sql 7.0 bol topic nesting stored procedures.

Thanks,
Peter



Thu, 15 Apr 2004 22:16:37 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Stored Proc Calling Another Stored Proc

2. How to call a stored Proc or Ext Stored proc /T-SQL UDF from VBScript

3. calling stored proc from stored proc via variable

4. Calling a stored proc within a stored proc

5. Calling Stored Proc from other Stored Proc

6. a stored proc calling another stored proc

7. Calling another stored proc within a stored proc

8. Calling a Stored proc within a stored proc

9. Calling Stored Proc from another Stored Proc

10. Calling stored proc from stored proc

11. Need Help on Dynamic Stored Proc Call within Stored Proc w/OUTPUT

12. Saving the resultset from a stored proc being called in another stored proc


 
Powered by phpBB® Forum Software