I have a stored procedure that is accessed by a client web page via asp. The stored procedure chugs anywhere between 10 seconds to 3 minutes, then produces a recordset based upon the parameters specified in the web page by the client, and formats the results in an asp web page.
More specifically the stored procedure returns three recordsets, one groups the our financial summary by Insurance Companies, another by individual insurance plans within their parent company and the last by the doctorproviding the service. I only show one at a time as they are pretty long, and reveal somewhat different info. I want to beable to click on a link on the resulting web page, which requests one of the other recordsets, without running the stored procedure again. Basically, once its been run, I want to beable to access the same stored proc result set created for one asp page, from a different page.
Example:
FinancialSummary.asp returns a web report listing Payments recieved by different insurance companies. I want to beable to click on a link, which changes the contents of the page to one of the other grouping options without re-running the stored proc.Whew. Good luck
-Sean