SQL Server rotary records

Posted on

Question :

I would like to know how to select routing records from a table. For example I have a table called disclosure and I want the records to be selected in such a way that today swallows the element x, y, z. Tomorrow, swallow y, z, x. The next day z, x, y, and so on. How to proceed?


Answer :

You can create a column and play random values through the RAND function and sort by this column.
Whenever you want to change sorting, just set new random values for this column.


Leave a Reply

Your email address will not be published. Required fields are marked *