Query the results from a stored procedure

I have some databases that use stored procedures for various functions, they return sets of data and I needed to query this resulting data. Found this good site on how to do it.