Register now or log in to join your professional community.
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.