#temp from prod - error on insert back into prod from #temp

[LNBruno]

Anyone hit this one before?

          SELECT *
           INTO #tempTable
           FROM dbo.ProdTable
          WHERE 1 = 0
          
         INSERT #tempTable
         SELECT --list of values from other tables; column count matches
         
 TRUNCATE TABLE dbo.ProdTable

         INSERT dbo.ProdTable
         SELECT *
           FROM #tempTable

Msg 213, Level 16, State 5, Line 1
Insert Error: Column name or number of supplied values does not match table definition.

NOTE: The error occurs at the end when attempting to insert into dbo.ProdTable.

< M!ke >
[small]Anything is possible if you don't know what you're talking about.[/small]

 

[SQLDenis]

<gibberish><.<.<. man, there not here</gibberish>

check your column list or maybe it is a computed column? An identity colum n would give you a different error



Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[AlexCuse]

I bet you one million dollars it is a computed column.

[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[LNBruno]

Denis, are you a member of the PDN (Psychic Developers Network)???

There WAS a computed column from the prod table!

Thank you for this valuable post! ;-)

< M!ke >
[small]Anything is possible if you don't know what you're talking about.[/small]