SQLTeam.com | Weblogs | Forums

Update data automatically


#1

Hi everyone
am new to the forum and i need your help please .
I have a table with 3 columns : column A, column B, column C .
in column B in every release there is new data that are saved i
i need to writ a function that compare the old data in column B with the new one and see if there is any new data if so add it automatically in the column C .
Thankyou in advance .


#2

Where do you have your new data? Is that in the same table, or in another temporary table perhaps?

update a set
   ColumnC = b.ColumnB
from
   PermanentTable as a
   inner join TempTable as b ON
      a.ColumnA = b.ColumnA
where
   a.ColumnB <> b.ColumnB;

#3

In the same table , but i want to stor it in the column C i mean the new data that is in column B


#4

An alternative way to do this is to have an "Audit table", with the same columns as the main table (plus an additional column for ChangedDate/Time) and then to use a TRIGGER to save the previous values into the Audit Table whenever a row(s) is/are changed in the Main Table.

Dunno if that would suit your needs, I'm just mentioning it in case of interest :slight_smile: