amalanto in that case you have to create a table which will capture the results inside the stored procedure; so you need to know the structure and datatypes returned;something like this:
create procedure myproc
as
begin
create table #tmp(tmpid int, columnlist.....)
insert into #tmp(tmpid,columnlist.....)
EXEC myotherProc
--do more stuff to the contents of #tmp
end
Lowell