handling multiple record sets
So SQL can only return up to 8000 chars in a vchar field.. right? Well, I’m working on a page that has software that makes a chart that can handle a lot of data. There are YEARS of data w/multiple entries per day of things to select from to make up this chart. As it stands, the stored proc that extracts the data sets up a cursor to loop through everything, perform some calculations to get a result (in the form of xx.xx) and appends each result to one varchar field which is then returned as one of the fields that comes from the result of running this stored proc. I want to get all the data tho. Because you can’t run a cursor/if/while statement w/in a select statement (i.e. the select statement that would return the result set for the stored proc), the only way to send all of the data is through multiple result sets.
This brings me to my question:
How can I handle multiple result sets from running one stored proc in classis asp.