Random Number on SQL without using NewID()
Posted
by Angel Escobedo
on Stack Overflow
See other posts from Stack Overflow
or by Angel Escobedo
Published on 2010-02-11T20:39:40Z
Indexed on
2010/03/24
5:23 UTC
Read the original article
Hit count: 298
Hello I want to generate a Unique Random number with out using the follow statement :
Convert(int, (CHECKSUM(NEWID()))*100000) AS [ITEM]
Cause when I use joins clauses on "from" it generates double registers by using NEWID()
Im using SQL Server 2000
*PD : When I use Rand() it probably repeat on probability 1 of 100000000 but this is so criticall so it have to be 0% of probability to repeat a random value generated
My Query with NewID() and result on SELECT statement is duplicated (x2) My QUery without NewID() and using Rand() on SELECT statement is single (x1) but the probability of repeat the random value generated is uncertainly but exists!
Thanks!
© Stack Overflow or respective owner