>Hi Borislav
>
>>>I have 2 SQL SELECT statements, executed one by one. The problem arise when I wanted to use the returned cursor of the first SPT in the second. The backend is SQL server.
>>>
>>>How can I acheive this? Please advise.
>>
>>How to use it?
>>To update something or you want to use it to filtering data?
>
>It is more like further JOINing. I mean the first SPT uses a few backend tables and creates a cursor in VFP. The second one again does a SPT, but this time the just created cursor is JOINed with another backend table to create a second cursor to be used seperately.
>
>Hope this is what you wanted to know.

another way is to create a temp table on the sql server , populate it with filtered records ( incase u need filtering) and use the same for a join with the second spt

suhashegde