December 9, 2003 at 9:38 am
I have a stored procedure that creates several sets of temp tables to get the final resultset. Each statement creating the temp table requires parameters so a series of views won't work. I also use these same statements in other stored procedures. Can a stored procedure be executed within another stored procedure with the results in a temp table?
December 9, 2003 at 12:52 pm
nested procedures calls are allowed, but you will have problems if you populate tables in this way.
INSERT INTO Table
EXEC WhatEver
December 9, 2003 at 12:57 pm
Is this a double post?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 10, 2003 at 5:30 am
If you need a parameterized view, use a udf that retuns a table. Its much easier to develop, test, and deploy then nested procedures using the INSERT INTO statements.
Christopher DeMeyer
Christopher DeMeyer
December 10, 2003 at 3:15 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply