>>>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

Actually, I said that you can call stored procedure using SQLExec, and this stored procedure can include multiple SQL-Select commands, and here you get multiple cursors on front-end.