>hi all,
>
>i am expected to generate a question paper consisting of 150 questions from a database of 2500 questions. Further, I am supposed to generate the question paper each time someone is required to take a test by RANDOM selection of questions from the above database.
>
>Can someone please enlighten me as to how i can go about RANDOMLY selecting 150 questions each time as i do not have the slightest idea as to how to go about this task ?
>
>With sincere thanks.
rand(-1)
select top 150 rand(), * from questions order by 1
PS: Depending on version you've a chance to get more than 150.
Cetin