Home Forums SQL Server 7,2000 T-SQL UDF to create a counter RE: UDF to create a counter
downes
SSC Eights!
Points: 840
More actions
January 25, 2008 at 8:17 am
#771773
I tried something like this....
cast(rand()*DATEPART(ms,getdate())*300 as int)
.. it creates a number however the numbers are identical.
I need something that creates a unique number. It does not have to be sequencial just unique per row.:cool: