December 25, 2015 at 12:55 pm
Welsh Corgi (12/25/2015)
INSERT INTO PrismData.dbo.tblcall
SELECT * -- TOP 5000 arc.*
FROM PrismDataArchive.dbo.tblcallArchive AS arc
WHERE YEAR(arc.Call_Date) IN (1998)
COMMIT TRANSACTION
-- ROLLBACK TRANSACTION
Msg 213, Level 16, State 1, Line 12
Column name or number of supplied values does not match table definition.
I have compared the structures and they are the same.
Any ideas?
Yes.
1. Get rid of the function on the arc.Call_Date column.
2. Compare the columns and data types again and find the difference. Using a column list in both parts can help. Remember to look for identity columns, calculated columns and such. You can use sys.columns if needed.
Viewing post 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply