I am getting an error when attempting to update records in a SQL table with records from a second SQL table on the same server and the same DB.
" Cannot insert the value NULL into column 'AColumnName', table 'My_Table'; column does not allow nulls. INSERT failed"
The table name shown in the error is not the table I am trying to update. Can someone help me understand why I am seeing a totally different table name in the error?
This is on a SQL Server 2016. The code I am using works on a SQL Server 2008.