Let's say I have the following table:
Order By OrderDate
Is it possible in the above to randomly swap the field to order by?
Say it's OrderDate but in the next reload it can randomly order by CustomerID or ProductID.
How is it possible to do this? Any ideas?