Just a quick question to you most knowledgeable people
I know who to create a result set from a data source, and 99% of the time things work as they should, but what I would like to do is hit the data source once and then create a result set which I can then create additional smaller results sets from to populate ranges in excel.
Basically I only want top hit the data source once. Then load everything in to memory, and then use the returned result set separate from the data source to return data depending on SQL feed to it.
Can this be done, and if so how?
All help greatly appreciated
Thanks#Spence
I know who to create a result set from a data source, and 99% of the time things work as they should, but what I would like to do is hit the data source once and then create a result set which I can then create additional smaller results sets from to populate ranges in excel.
Basically I only want top hit the data source once. Then load everything in to memory, and then use the returned result set separate from the data source to return data depending on SQL feed to it.
Can this be done, and if so how?
All help greatly appreciated
Thanks#Spence