You can always index the cursor
>Plus, after I pull over those 43,000 row from 'Jobs' in Sql Server, it won't be indexed, so, when I use it in a join with the local cursor, it seems like it will impact the speed of the local Select statement.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer