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

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

HCL healthcare

 hcl health care f2f second round interview asked more uestions on microservice 1.apim manage all apis in one place 2.sql profiler in one fo...

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • generate APK using capacitor
     D:\A-MyProjects2024-2025\ReactNative2025\BookRental\android\app\build\outputs\apk\debug path of apk To build an Android app using Capacitor...
  • Dtabase design
      OLX, like many large-scale online platforms, employs a variety of data structures and technologies to manage its data effectively. While s...