dynamically creating the #temp table and then used to insert the data
- by praveen
Hi All,
I am importing an intermediate result of query into a temp table for further use, so I used a #temp table to maintain the same schema as
select * into # temp from schema.tableName where 1<1;
insert into # temp from exec(table)
While I am doing this statement as a variable to pass the different tableName its not working
SET @TEMPSCHEMA = 'SELECT * INTO #temp FROM ' + @PKSchema + '.dbo.' + @PKTableName + ' WHERE 1<1;'
exec(@TEMPSCHEMA)
INSERT INTO #temp
EXEC ( @SELECTSTATEMENT
)
however after exec statement it is not taking the values to the temp table.
it is showing the invalid object id #temp
