Hi

I am uisng following code. How do create a table for insert into when 2 resul sets are differnt? Please advice.

CREATE procedure PROC1 as

begin

Select 'aaa',1

select 1,2.22,'xxx'

end

go

DROP PROCEDURE PROC2

go

Create procedure PROC2 as

BEGIN

INSERT INTO #temp

EXECUTE PROC1

SELECT * FROM #temp

END

go

execute PROC2

Regards

Krishna