>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.
>
>
See the alternative solution I provided. I used this technique in few places.
If it's not broken, fix it until it is.
My Blog