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

>>