>>I need to select data using SQL Passthru ( SQLExec() ) from multiple permanent tables into an intermediate result set, then join the intermediate result set and some of the permanent tables to create a final result set. I cannot seem to be able to get this to work. Can this be done without using a stored prodecure, and if so, how? MS SQL Server 6.5.
>>
>>Thanks,
>>Bill
>
>I think you should use stored procedure integrated into SQL Passthru (SQLExec(nConn,"execute proc1")). Actually VFP will get as many cursors as number of Select statements you will issue inside the procedure.

Hi Edward,

We will eventually include as stored procedure. Right now we are trying to develop the code. Are you saying to execute more than one SQl Select in a single SQLEXEC() statement? I was wondering if this could be done, but was not sure.

Thanks,
Bill