Instead of temp table if you could use a function that returns a table then i think it will work for you.