CREATE TABLE #temp1 (msg1 varchar(50) NULL) CREATE TABLE #temp2 (msg2 varchar(50) NULL) INSERT INTO #temp1 EXEC proc1 INSERT INTO #temp2 EXEC proc2 SELECT * FROM #temp1 CROSS JOIN #temp2 DROP TABLE #temp1 DROP TABLE #temp2>I have two stored procedures that return 1 field each.
>Create Procedure Proc1 >as >select 'FromProc1' as Message >go > >Create Procedure Proc2 >as >select 'FromProc2' as Message >go > >declare > @RetVal1 varchar(50), > @RetVal2 varchar(50) > >exec @RetVal1 = Proc1 >exec @RetVal2 = Proc2 > >select @RetVal1,@RetVal2 > >go >