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 ; && qty_recd <> before_qty_recd ; needs to be taken care of by Matt when producing CSV_ListOfValuesProducedLocallyIntoString
              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 ;