Mike C (6/9/2009)

---

Jeff Moden (6/9/2009)

---

Mike C (6/9/2009)

---

Another minor quibble - each instance of RAND() is invoked once per query.

SELECT RAND(), RAND()

Generates two different random numbers because RAND() is actually called twice. Each RAND() result is repeated for every row of the result set (in this case only one row).

Heh... correct identification of the problem in 90% of the solution. We know the behavior and the work around. Use the work around.

LOL Jeff. I wrote a chapter about 4 months ago that uses the CHECKSUM(NEWID()) method to generate "random" test data.