Your sample works great. What I was trying to accomplish is to move the procedure results directly into two declared fields (@RetVal1 and @RetVal2) and not temporary tables. And I’m not sure how to do this since the procedures are only returning a single value.
>What exactly doesn't work for you in the code I posted?
>
>>we already have proc1 and proc2 in place and they are bing used by other programs. what I am trying to do in proc3 is get a single value from these two procs combine them and return is as a single value to VFP.
>>
>>>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
>>>