Code is something like this:
Update Inventory
SET Price = (SELECT Inventory.Price
FROM farwest.dbo.Inventory T2
WHERE T2.ItemNum = Inventory.ItemNum);
I need to update the Price column in the Inventory table from DB farwest into the Price column from table Inventory in the sanroque DB.
I keep getting this error:
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'Price', table 'sanroque.dbo.Inventory'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
I have no NULLS in either table!