Last post Oct 13, 2010 04:29 AM by KumarHarsh
Oct 13, 2010 02:48 AM|Mobzam|LINK
I have two tables. One is holding records temporarily while the other is master table. I am trying come up with a sql that will be picking a record at a time from temporal table then check is if the record has been update dated in the master table. If it
has been updated it does nothing else it updates. Now I am having challenges. The table fields are as follows: Please help
Id Firstname Surname Location Amount status Position
Oct 13, 2010 04:29 AM|KumarHarsh|LINK
Updated means what in broader sense ?
You can look for id in master table.
If it exists then do nothing
insert that id record from temp table
insert into master table
Select * from temptable where id not in (Select id from master table)