Nested Stored Procedure

[arpan]

Can anyone suggest me some URLs where I can find examples on how to create nested stored procedures?

Thanks,

Arpan

 

[mwolf00]

Are you trying to see how to call one SP from another? I don't think that they actually nest....



CREATE PROC main_proc
AS
-- in the next line @infoBox is populated by the other SP...
EXEC sp_requestInfoBox @requestID,null,null,@infoBox output
...
GO

CREATE PROC dbo.sp_requestInfoBox(
@requestID INT = NULL,
@requestCode char(7) = NULL,
@tempID INT = NULL,
@infoStr varchar(1500) OUTPUT
)

AS
....
GO
-- What did you expect? This is FREE advice. LOL

 

[iowtech]

I beleive you can nest SP's up to 32 levels.

Might I suggest a google seearch:

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q="nested+stored+procedures"