SQL to copy data from one table to another
Posted on 2009-05-12
I have two tables, one
HistorianData which has a lot of fields e.g. TimeStamp, TagA, TagB, TagX
DataDump has two fields Timestamp and TagX
I want to copy the TagX field from the DataDump to the HistorianData table where the Timestamp values match (so that the DataDump table can be deleted).....I got a data dump from client (HistorianData) and they forgot all the fields so need to join them
How can this be done with transact-sql?
I thought something like this but get error
The multi-part identifier "DataDump.TIMESTAMP" could not be bound.
SET [historiandata].[TagX] = [DataDump].[TagX]
[historiandata].[TIMESTAMP] = [DataDump].[TIMESTAMP]
Thanks in advance for help!