lois waisbrooker Total Post:70 Points:494 Posted by lois waisbrooker May-07-2013 0:23 AM MSSQL Server MSSQL Server 1 Reply(s) 1693 View(s) Ratings: Rate this: Hi! Everyone! I am working on a survey application. I have a sql server database holding upto 3000 survey questions. I call database for a set of 10 questions. I have to make sure that none of the of the questions are repeated for the longest time possible. What is the best possible approach I can take here? Write a custom randomization algorithm or SQL server provides some functionality. Please help me! Thanks in advance!