Dear Friend,

How about looking into manipulating the current system date & Time.

Use GetDate(), Remove the spaces and append with some other characters / digits of your choice (Based upon some logic, if you find comfortable).

Lets Say GetDate() Returns :- 2009-01-21 19:06:26.777

Trim The "-" Then 20090121 (8 Characters)

Remove ":" Then 190626 (6 Characters)

Remove "." Then 777 (3 Characters) Take First 2

So the Key 2009012119062677 = 16 Digits.

It can't be duplicated never ever - As the same date won't repeat back again.

Take Care

Bye

Happy SQLing...