Hello everyone,
I am trying to create a temp table and then insert some records in there:

DECLARE @StrCreate varChar(500)
SET @StrCreate = 'CREATE TABLE #curReport (ID Int, F1, F2...)' -- String,actually gets build for crosstab report
EXECUTE(@StrCreate)
SELECT * FROM #curReport

It does not see #curReport after EXECUTE.
If there any way around this.
Please help.

Thanks in advance..