SQL - Choosing Random Records Depending on the date
What I want to do, is whenever the script is called show a random set of 20 records. However, for a whole day, I always want the same 20 random records to be shown.
I don't want to have to label those records or anything like that. Therefore I am assuming that the 20 records will be called depending on the date eg. 11/21/11, 11/22/1 etc.
I don't mind if certain of the table records are shown on more than one date. I also don't really mind if some of the records are never shown although ideally would like to avoid both of these things.
I am using ASP/SQL Server, although I am pretty sure that in any language the concept will be the same.
Can you guide me at all?
Thanks,
Ben Shaffer
Steal Amazon, Kindle and Buying Keywords In Seconds!