I would appreciate some help with the following problem.
I have a table that must be displayed in a different order each week. So I am looking to create a SP to update a field in the table with a random number. The SP could then be scheduled to run overnight once a week.
I tried updating the table using rand() but each record received the same value.
This would be easy in VB6 or ASP.NET using a recordset, but I can't see how it can be done in SQL Server.
Any help would be appreciated.
I have a table that must be displayed in a different order each week. So I am looking to create a SP to update a field in the table with a random number. The SP could then be scheduled to run overnight once a week.
I tried updating the table using rand() but each record received the same value.
This would be easy in VB6 or ASP.NET using a recordset, but I can't see how it can be done in SQL Server.
Any help would be appreciated.