Calling a stored proc within a stored proc 
Author Message
 Calling a stored proc within a stored proc
I have looked everywhere (obviously not well enough) to find out how to call
an SP within an SP but cannot find how to do so.
Please could you tell me how to do this (with passing a single argument).

TIA



Sun, 28 Aug 2005 18:12:09 GMT
 Calling a stored proc within a stored proc


Quote:
> I have looked everywhere (obviously not well enough) to find out how to
call
> an SP within an SP but cannot find how to do so.
> Please could you tell me how to do this (with passing a single argument).

> TIA

Answered my own question. Apologies.
Example:



Sun, 28 Aug 2005 18:22:51 GMT
 Calling a stored proc within a stored proc
Read about EXECUTE in Books Online.


--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


Quote:
> I have looked everywhere (obviously not well enough) to find out how to
call
> an SP within an SP but cannot find how to do so.
> Please could you tell me how to do this (with passing a single argument).

> TIA



Sun, 28 Aug 2005 18:51:06 GMT
 Calling a stored proc within a stored proc
Thanks!


Quote:
> Read about EXECUTE in Books Online.


> --
> Jacco Schalkwijk MCDBA, MCSD, MCSE
> Database Administrator
> Eurostop Ltd.



> > I have looked everywhere (obviously not well enough) to find out how to
> call
> > an SP within an SP but cannot find how to do so.
> > Please could you tell me how to do this (with passing a single
argument).

> > TIA



Sun, 28 Aug 2005 18:49:51 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Calling another stored proc within a stored proc

2. Calling a Stored proc within a stored proc

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

4. How to get results from Stored Proc within a Stored Proc

5. Exec store proc within a store proc

6. populating a temptable from a stored proc within a store proc

7. newbie trying to execute a stored proc from within a stored proc

8. Create large Stored proc from within stored proc

9. Stored Proc within a Stored Proc

10. Stored Proc Calling Another Stored Proc

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

12. calling stored proc from stored proc via variable


 
Powered by phpBB® Forum Software