I ahve a stored procedure which I need to call then refilter / requery that data w/o another hit to the DB. I am combining 10 recordsets which are currently called individual from eachother, making 10 requests and 10 responses. Its an expensive trip. Each of the stored procedures are identical with the exception of the CategoryID parameter changing for each of the 10 instances. I would like to call a master recordset, without the CategoryID filter, loading all records. I then want to requery or similar to get the data from that masterset filtered by a particular CategoryID. I am trying to do this with just the 1 call to the DB. Any ideas?
I responded to your previous post titled, "Combining 16 Stored Procedures" at http://forums.digitalpoint.com/showthread.php?t=1334293