RAND returns same dataset everytime it's run
Posted on 2011-05-03
I want to extract a random list of X number of customers every month. Here is my query:
SELECT TOP (10) Customers.Name, Customers.Address, Customers.City, Customers.State, Customers.ZipCode, RAND() AS Random
Microsoft says to leave the seed blank to get a random dataset each time, but this query is getting the same dataset everytime.