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..
XO4Y BCE 3HATb,YMETb,IMETb!