My apologies if this has been answered elsewhere, but I was unable to find an answer.

I have a stored procedure that returns multiple recordsets, but the Command feature only allows you to name one recordset. Likewise, when you test the procedure only one recordset is returned. Does anyone know how to use a stored procedure that returns multiple recordsets to DMX so that you can use them in the Data Bindings window?

It seems to me that it would greatly reduce the amount of code on the page to only call one stored procedure (if possible). Any thoughts?