i have problem in producing the auto generated number. my requirements are to produce series of numbers like that
after that the number changes to
the last number should be
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.