it depends on the seq. number .. seq number is alloted as transactions come in  .. they are in chronological order.

thanks,

Thanks man. It helped.

So the idea here is to Generate 2 -3 million consecutive unique numbers by using 5 Alpha Numeric digit. Please if you can help around this will be great.

When EZ9999 incrments to E0A001, what happens as E0A999?

ans : When EZ9999 increments to E0A001

then afterwards It E0a999 will be increment to E0B001

Or What can be done is

After...

Totally agree, but this is the task I got to do this.

Totally Blank , Plz see if you can suggest something.

Hi Sean- It always be 5 digit Code + constant.

Thank You , Everyone for the Help !

Thanks Celko, I will keep your advice in my mind !

Is there any other way to achieve this without CTE.

I want 678 too in my report.

Hi Sean ,

Thanks for the reply , can you just give me a little bit overview , how can I use partitioning in my current situation.

Thanks.

Thanks a lot Guys !!!!

Thanks for the quick reply

but i am getting error

Msg 8117, Level 16, State 1, Line 56

Operand data type char is invalid for sum operator.

when I am trying to use logic...

Thanks Everyone for your Time and effort!!!

I have used Dynamic Cross tab to deal with this thing, Now i need help in sending pipe delimited data to a text file..

Scripts...