Hi Simon, Thanks for the quick reply, Your solution worked flawlessly!
I had to change the Trigger code by adding "FOR EACH ROW" (it would not accept it is a valid trigger else) Cheers, Nadav. nadavius wrote: > > Hi guys, > > I have two tables T1, T2 - identical in fields [Index1 (INT), Index2(INT), > Count(INT), Value(INT)] > I would like to merge the content of T1 into T2 using the following ruels: > 1. Copy into T2 data from T1 where Index1 AND Index2 (like two keys, PK > and SK) do not exist in T2 > 2. In case that there are common rows between T1 and T2, where common > means T1[Index1, Index2] and T2[Index1, Index2] are the same - update > T2.Count and T2.Value ONLY IF T1.Count has a greater value > > I am looking for an efficient SQLite statement to make it work. > > Any ideas? > > Nadav. > -- View this message in context: http://old.nabble.com/Smart-merge-tp32873853p32874964.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
