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