Home Forums SQL Server 2005 SQL Server Express Generate 5 digit random numbers RE: Generate 5 digit random numbers
ola_blixten
SSC Veteran
Points: 272
More actions
June 18, 2008 at 1:07 am
#830230
Okey, it should look like this.
|week|year|serialnum|
01 0 00001
01 0 00002
01 0 00003
01 0 00004
...so 99999 on 1 week, then it turn over to week 02 and continue..:)
thanks