FAQ.Does SQL Plugin handle stored procedures with multiple result sets?Answer:
Yes, the plugin can work with multiple recordsets.Notes:
You need to use SQLCommandMBS class. When you get back results, you use FetchNext to walk over all records in the first result set. Than you simply start again with FetchNext to get the second record set.
Even the RecordSet functions should work, just use them twice to get all records from both record sets.