Viewing 2 posts - 1 through 3 (of 3 total)
in oracle I use:
merge into MonthsImports MI using (select...) I on MI.id = I.idwhen matched then update set MI.id = I.id ...when not matched then Insert MI.id... values(I.id...)
merge into MonthsImports MI using (select...) I on MI.id = I.id
when matched then update set MI.id = I.id ...
when not matched then Insert MI.id... values(I.id...)
I dont have...
August 10, 2010 at 1:15 am
#1204517
OK. Every month the Import table is filled with the current information about the salaries. I have to store the whole history concerning the salaries in another table. For this...
August 10, 2010 at 1:01 am
#1204513