Home Forums SQL Server 2008 T-SQL (SS2K8) Problem with inserting the data into temp table RE: Problem with inserting the data into temp table
John Mitchell-245523
SSC Guru
Points: 148809
More actions
January 9, 2013 at 3:23 am
#1575132
The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:
SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME LIKE '#temp%'
John