Try:
CREATE TABLE #tempTable(Column1 INT, Column2 UNIQUEIDENTIFIER, Column3 DATE)
INSERT INTO #tempTable(Column1, Column2, Column3)
EXEC sp_executesql @query
SELECT * FROM #tempTable
DROP TABLE #tempTable
Or better, replace your SP with a table valued function.