Hi I have a stored procedure, which calls another stored procedure and I´m asigning the result to a variable.

Something like this,..

Code:
Declare @num int;
ALTER PROCEDURE proc 1
BEGIN
exec @num = proc2
 [Then do sth with @num]
Select * from table where id = @num
END
when I execute the procedure in the results I both get the value from the
exec @num = proc2 and the value from Select * from table where id = @num


I would like to asign the value of the stored procedure to @num, without it showing in the results when executing the procedure.

The reason is I and looping through results and it gave me this error:

The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.