I've cleaning up a bunch of classic ASP code and basically I'm taking about 10 stored procs that execute in sequence on a page and just creating one uber stored proc that brings back multiple records sets (I didn't write the first version of the page). For future reference, since I always forget this, the syntax is...
Set myrecordsetobj=myrecordsetobj.NextRecordset()
No special stuff needed on the stored proc's end, just use multiple selects.
No comments:
Post a Comment