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

Boy Edward, you are fast :-),

Then how do you go about developing the code for a stored procedure wihtout putting it in a stored procedure, or is this possible? SQL book seemed to indicate temporary stored procedures could be created by including "#" somewhere in the definition?

Bill