SQLSRV Multiple Results from SP

[eluser]sdjones[/eluser]
HI I have a requirement to use a certain stored procedure (SP) on MSSQL Server 2008

This SP runs multiple SELECT statements and returns, on success, multiple results (only 1 result on failure)

what i cant seem to do is loop through the result sets and grab all the results, is this possible using CI 2.x and the latest sqlsrv drivers?

any help is vastly appreciated.