I'm sorry but I don't understand what you're trying to do.

>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

>>>>