أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
use cursor and case or if conditions to do respective calculation and update accordingly...best is to do the same cursor and case or if statements in a procedure or function..is a good practice. thanks.