Create a View based on data stored in a Variable

Hi All ,

My end motive is something like below :

SELECT * FROM (EXEC MyProc) AS TEMP 

Please Advice