RE: Nested Stored Procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Riddick1980" wrote:

Can I use a stored procedure as table inside a stored procedure?
for eg. i have a stored procedure named QMENU and QNEWMENU
I want to use these two stored procedures in another stored procedure like:

CREATE PROCEDURE MENU(@roll1 as INT)
AS
BEGIN
SELECT * FROM QMENU;
UNION ALL;
SELECT * FROM QNEWMENU;
END

Thnx in advance,



.

Quantcast