If you need the values of a temp table you first want to create through a sp, then why don't you use a common table expression.

WITH cte AS

(

SELECT your fields

FROM...