Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calling a procedure from within a procedure
Message
From
07/04/2000 16:20:50
 
 
To
07/04/2000 10:32:05
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00356851
Message ID:
00357098
Views:
14
You've really provided sketching details but if the amount of data being returned from the inner stored procedure is small, say one or two items, you could return them as OUTPUT parameters.

If not, use the inner stored procedure to fill a temporary table. Check out the INSERT...EXECUTE command in the BOL.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform