Posted by Ecohouse on 11/05/05 15:40

I have a quick question for you about SQL stored procedures. If I'm
in a stored procedure and want to call another stored procedure and
return values from the second stored procedure what is the procedure?

I know you do the following to run the second stored procedure and pass
in any parameters:
EXEC GetAuthorBooks @AuthorID

So if I wanted the GetAuthorBooks to return all the books for an author
and then populate a temp table in the original stored procedure, how do
I return those records, and populate the temp table?

What do I have to add to this line: EXEC GetAuthorBooks @AuthorID?

• Next in forum: Re: Return Stored Procudure Values
• Prev in forum: MDF File Still Exists After DROP TABLE
• Thread view: Return Stored Procudure Values

[Reply to this message]