...
Code Block | ||
---|---|---|
| ||
update subscription_bundle set value4=case when value2 > (value1-value3) then value2 - (value1-value3) else 0 end where exists (select * from bundle b where b.id = subscription_bundle.bundle_id and b.parameters like '%UPDATE_MANAGER=ROLLOVER%'); |