How to uncommit the transaction and execute the next statement in the cursor?

Question

How to uncommit the transaction and execute the next statement in the cursor?

Viewing post 46 (of 45 total)

You must be logged in to reply to this topic. Login to reply

prakashr.r7 SSCrazy Points: 2828 More actions · Answer 1

If i need two characaters, i will check whether if any of the codevalue has 2 characters then i will update the same value into PnxCodeValue....and for the remaining rows, i will start with 99,98,97,96....00 and when it goes beyond 00, i will start getting the alpha numeric characters like 0A,ZC,1A....like that