Use this query to select data from a stored procedure :
sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
SELECT * FROM OPENROWSET('SQLNCLI', 'Server=servername\SQLEXPRESS;Trusted_Connection=yes;',
'EXEC dbname.dbo.sp_who')
You can even send parameters to that stored procedure.
Hope it helps.