Alan McDonald wrote:

>>Well I do flag the records using nested loops and it is much much faster
>>that way. However, when I am done I have on average anywhere from 100k to
>>2million records flagged for processing. This processing is done
>>outside of
>>the database by a 3rd part data services company. So I have to export all
>>the flagged records at once.
>>
> Can't you write an SP for them to use - so they, only, have permission to
> run it?

Expanding on that, since you obviously need the results of the third
party company, is there no way you can create an online link that will
allow access either to pull results from them, or as Alan says get them
to push data in.
Otherwise it would be a lot quicker just to zip up the whole database
and send that ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services