Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goligol
Posting Yak Master
128 Posts |
 Posted - 2011-06-01 : 11:47:25
|
| I am executing this commands:SELECT O, D, C, M, avg(V0) V0 INTO #temp FROM [dev].[Initial_Value] GROUP BY O, D, C, MTRUNCATE TABLE [dev].[Initial_Value]INSERT INTO [dev].[Initial_Value] SELECT * FROM #tempDROP TABLE #tempError Message:Warning: Null value is eliminated by an aggregate or other SET operation.502421 row(s) affected)Msg 213, Level 16, State 1, Line 3Column name or number of supplied values does not match table definition. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-01 : 11:49:52
|
| The dev.Initial_Value table has more or fewer columns than the #temp table. |
 |
|
|
|
|
|
Error message