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