how can I update a value in a dynamic lookup in the follow manner:
say I have an integer column in the lookup and on the next lookup I get a new integer that should be added to the existing value.
how can i achieve it?
I have the empty source table
emp_id | value
row insert emp_id | value
1) 101, 1000 expecting insert 101 1000
2) 101, 1005 expecting update 101 2005
3) 101, -300 expecting update 101 1705
I hope my example is clear