How can I get random numbers from SQL Server? Using rand() I always get the same sequence.

A. A. This is because you need to start the rand function off with a random number. Use something like :-

SELECT RAND( (DATEPART(mm, GETDATE()) * 100000 )
+ (DATEPART(ss, GETDATE()) * 1000 )
+ DATEPART(ms, GETDATE()) )

---