how to weekly once increment id

Nirmal KumarC

12y1.4k

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 valuePSSR/B1098/REO/B101 insert Batchid to database this result

another one Example:  ARPA/B146  this id increment create ARPA/B147

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirmal KumarC12y ago
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 getCHEMCO/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 Patil12y ago
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.