Hello. I am using a sql server 7 db and want to randomly select a record from the db from a selected table.
How can I go about do this. I was thinking about getting the record count and then using the random function in VB to get the record, but if this where to be repeated in a loop, I think it would take a bit too long if there are many records in the DB.
Can anyone help me?
