Sequence Number generation and reset
Hello Experts
how to generate 1 - 10 number generation and after 10 it should reset to 1
example - BC - first record 1
second record 2
Third record 3
Fourth record 4
--------------------------
--------------------------
--------------------------
--------------------------
Tenth Record 10
eleventh record 1
--------------------------
--------------------------
--------------------------
How to achieve this solution
Regards,