how to weekly once increment id

Question

I want PSSR/B1097/REO/B100 ARPA/B146 get data to database After Split the PSSR/B split 1097 and REO/B separate 100 1097 value increment 1098 100 Value Increment 100 after this value PSSR/B1098/REO/B101 insert Batchid to database this result another one Example: ARPA/B146 this id increment create ARPA/B147

Nirmal KumarC · Answer

I want How to weekly wise one time all batches as Batch id increment using Sql server with cursor example below. Batches Example: Batches: CHEMCO/B73 /PSF/180 ERS/B366 ARPA/B146 EFA/B989 PSSR/B1096 RECP/B175 ERS/B367 So this All Batch id Dynamically get this result in below I want CHEMCO/B73 /PSF/B180/ ERS/B367 get data to database After first Batchid Split the CHEMCO/B separate 73 above 73 Value Increment 74 After Split the second value PSF/B separate 180 180 Value Increment 181 Value final value Split ERS/B separate 67 67 Value Increment 68 finaly above all value join is value batch id get CHEMCO/B74/PSF/B181/ ERS/B368 want this result another one Example: split this batchid PSSR/B1096 this id above same method using increment batchid increment this result PSSR/B1097 Thanks

Abhijit Patil · Answer

Dear Nirmal please elobreate your question we are not get what u want to say exzactly. if we get your proper question then we help only. hope you understand.