Cindy,
Thank you for the quick reply.
Yes, in fact I do have a delimiting feature already built in, but that is for the user to set. However I am writing this as a generic class where I can not know what the data will look like before hand, so I can not make those kinds of guesses.
I guess what it comes down to is, I need a way of returning a cursor on it's own thread???
-- Chris
>Chris,
>
>When I do large ad hoc SQL Pass-through queries I usually adjust the WHERE clause to get a few months of data at a time. You could also do a few letters of the alphabet if the data is alphabetical.
>
>
>
>>Hi everyone.
>>
>>I have come across a situation where I need to background fetch a large result set (1.2 million records or more) from SQL Server...
>>
>>Is there some combination of asynchronous, batch mode on/off and SQLMoreResults that will let me break apart the query and come back with manageable chunks at a time?
>>
>>Thanks for your help.
>>-- Chris
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only