im using this code and getting the following any ideas why
UPDATE dbo.TempSimulation
SET generic.HistoricalPrice.ShareCurrency= dbo.TempSimulation.ShareCurrency
FROM dbo.TempSimulation
INNER JOIN generic.HistoricalPrice ON
dbo.TempSimulation.ThirdSimulation= generic.HistoricalPrice.ISIN
Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "generic.HistoricalPrice.ShareCurrency" could not be bound.
if that still doesn't work: "could not be bound" error often means that the table definition was changed (like a dropped/renamed column). If either of these objects are views and the underlying DDL changed then then you need to recompile the view and don't use "select *" in the view but rather an explicit column list.
that doesnt work i have to have it like this SET g.ShareCurrency = t.ShareCurrency as i want to update the t.sharecurrency values with the g.sharecurrency values so when i change it back get same error
multi-part identifier error
Posted - 03/13/2013 : 10:59:54
