is it possible to replace data from one column to another in a table say table a and also at the same time replace data from a column say in table b to a column in table a
Yes if there is a unique field you can link them between.
How do you have table a and b setup?
quote:Originally posted by rjhe22
is it possible to replace data from one column to another in a table say table a and also at the same time replace data from a column say in table b to a column in table a
ya have uniqu key need it something like this but it wont work i have found a few things on the net but they all do it different way and im not sure whats the right way. the one i was following was somthing along these line
UPDATE dbo.TempSimulation SET dbo.TempSimulation.ThirdSimulation = dbo.TempSimulation.ISIN, generic.HistoricalPrice.ShareCurrency = dbo.TempSimulation.ShareCurrency FROM dbo.TempSimulation INNER JOIN generic.HistoricalPrice ON dbo.TempSimulation.ThirdSimulation= hp.ISIN
using replace
Posted - 03/13/2013 : 08:21:10
