Here's basic code that shows how it can be done.

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.
>It is being used by other programs.
>We can not modify these procedures.
>I’m trying to combine the return values from these two procedures and return a single table back to VFP.
>Also I do not want the result of the 1st two procedures returned to VFP.
>Can you help?
>Here is a SQL example:
>

>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
>