Is this using SQLServer? If so there's a trick you can use with the NEWID function. It generates a random guid so you can use it to randomly order a dataset then pick the first record:-
Select Top 1 * From MyTable Order By NEWID()
|
Results 1 to 2 of 2
Threaded View
Tags for this Thread |
Click Here to Expand Forum to Full Width |