Madhivanan shows us how to query the results of a stored procedure:
One of my friends asked me “Is it possible to query Stored Procedure resultset like a table. ie select * from (EXEC Stored_procedure)?”
Well. Querying the resultset from the Stored Procedure like Table can be done using OPENROWSET function
This is a fairly novel approach to the problem. In the past, I’ve inserted the results of a stored procedure into a temp table, but you can only do that if the procedure itself doesn’t call INSERT INTO ... EXEC ....