This past week, I had an issue where I needed to randomize the data coming from SQL to use in a SqlDataReader in an ASP.NET page. I posted an issue on the ASP.NET forums and soon received help from Scott Mitchell. He pointed out that in the stored procedure I can use the code:
Select *
From MyDatabase.MyTable
Order by NewID()
Of course, since Scott is the .NET Data Objects King, it worked like a charm. He received that information from http://sqlteam.com/item.asp?ItemID=8747. Thanks to Scott for the help.