Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
aswindba1
Yak Posting Veteran
62 Posts |
Posted - 2013-04-17 : 19:39:25
|
I have a table on a datawarehouse server containing Server, Application etc.. information, and I would like to have a query that updates that table from the live version of the table. However, there are a lot of records, so I don't want to truncate and re-populate that data each time. I would like to insert any new records and update only records that have changed....for example...Table has one million records containg server, application and some other columns with respective these columns.Every month new Servers and Application's are added to the table. So, Ineed to update the columns only for these servers. |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-04-17 : 19:44:57
|
Sounds like you want a merge statement.-Chad |
|
|
|
|
|