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: