如何在一个过程中调用另一个过程返回的结果集？急！在线等！

REDMOB

我有一个存储过程，执行后返回一个结果，如SELECT效果，现在我想在另一个存储过程中调用它返回的结果集，请问各位大虾们如何实现，最好给个例
急急急！！！！！
在线等答案！！！！

zhangyh123

考虑使用全局临时表？

REDMOB

小弟有一个问题使我总是不敢用全局临时表：
在并发式操作情况下使用全局临时表会不会导致冲突？

2BeSybPro

When both a create procedure statement and an execute statement include the output option with a parameter name, the procedure returns a value to the caller. The caller can be a SQL batch or another stored procedure. The value returned can be used in additional statements in the batch or calling procedure.

This stored procedure performs multiplication on two integers (the third integer, @result, is defined as an output parameter):

create procedure mathtutor
@mult1 int, @mult2 int, @result int output
as
select @result = @mult1 * @mult2

To use mathtutor to figure a multiplication problem, you must declare the @result variable and include it in the execute statement. Adding the output keyword to the execute statement displays the value of the return parameters.
declare @result int
exec mathtutor 5, 6, @result output
(return status = 0)
Return parameters:
-----------
30