Yes, it can be done. I would send a parameter to the stored procedure and iterate through the stored procedure with a loop and continually pass the new value you want until you have all of the results needed.
Do you need to have an example of the stored procedure or asp code?
Edward M. Sokolove