Posted by Erland Sommarskog on 11/05/05 16:29

Ecohouse (vindaloo1@netzero.com) writes:
> 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?

There are a couple of methods, and I have an article on the topic on
my web site: http://www.sommarskog.se/share_data.html.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]