Monday, 22 July 2024

seqnce update after delete

 UPDATE tbl_WorkFlowMembers

SET Approver_Sequence = Approver_Sequence - 1

WHERE WorkFlow_ID='RAILMY00009' AND Approver_Sequence > 1;


i have sequence like this  to make proper imporved using above like this
Approver_Sequence 1 3 4 5 6 7 8

No comments:

Post a Comment

kidney stone?

  Foods that increase kidney stone risk include those  high in oxalates (like spinach, nuts, and chocolate), sodium (processed and fast food...