can we able to count how many number of resultset is returned by a stored procedure?
i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters.
so i need to count how many resultsets are returned by the sp