now that needs a review by my architecture team - lets see
Select Users.email ;
From Jobs ;
Join Users On Jobs.quoted_by = Users.emp_num ;
Where ;
Jobs.job_num in (&CSV_ListOfValuesProducedLocallyIntoString)
Order By 1 ;
Group By 1 ;
where to send my teams bill ;-)
(No Dragan, I won't send any William over, neither to the states or to shovel your snow)
>The only problem is that in the Where clause, you are still referring to fields in my local FoxPro cursor.
>
>
>Where qty_recd <> before_qty_recd
>...
>
>
>
>
>
>>>>The alternative way is to pass local cursor to the SQL Server, e.g. something like this
>>>>text to lcInsert noshow
>>>>declare @LocalTable (field1 varchar(10), field2 int)
>>>>endtext
>>>>
>>>>select local cursor
>>>>scan
>>>>
>>>> using textmerge create insert statements for the local cursor
>>>>endscan
>>>
>>>Does that @LocalTable remain in the Sql Server database afterwards?
>>>
>>>And, what if you have multiple users doing this process at the same time? They will all be trying to use the same @LocalTable and the records would get all jumbled up.
>>>
>>For such tiny local cursors used as join filters you can locally pipe their PKs into a
server.pk IN (client.pk1, client.pk2... client.pk_max)
value_set clause to be used on the server in the where-clause.
>>
>>
Select Users.email ;
>> From Jobs ;
>> Join Users On Jobs.quoted_by = Users.emp_num ;
>> Where qty_recd <> before_qty_recd ;
>> and Jobs.job_num in (&CSV_ListOfValuesProducedLocallyIntoString)
>> Order By 1 ;
>> Group By 1 ;