Auto Generator Number - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Auto Generator Number

shehparshehpar Posts: 3Member
Dear All,
i have problem in producing the auto generated number. my requirements are to produce series of numbers like that
AAA-0000
AAA-0001
up
.
.
.
AAA-9999

after that the number changes to

AAB-0000
AAB-0001
.
.
.
.
AAB-9999

the last number should be
ZZZ-9999

If there is any person who help me in producing that module / algorithm or piece of code in C# / T-SQL, i will be thankful for that.

NOTE:- the number should me auto generated i.e., after one transaction the new number would be generated.
or. in case of T-SQL, when inserting new record, the eky would be that number like the example that i stated above.

Hope that there is someone which will help me.

Best regards.
Sign In or Register to comment.