>>Get your Jobs and Users into local cursors and then join with them locally.
>
>The Sql Server table 'Jobs' has 43,000 rows in it and I need to join them with a local cursor that has about 8 rows in it to find the 8 matching records in 'Jobs' based on a lookup field.
>
>So, are you telling me I habe write one Sql Server query to pull over all 43,000 rows to a local cursor, then write a FoxPro select to join them to the other existing local cursor?
>
>Yikes!!! That's ugly.
>
>
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