Order by newid() (Random Rows)

[suoirotciv]

Order by newid()

I got this from thread183-1208594 and it really works. Thanks a lot.

But just one question.

I have 300 to 400 users and we have atleast 20,000 to 30,000 records. What is the possibility that these users will get the same record?

========================================
I kept my Job because of TEK-TIPS
Thanks a lot to all who keeps on helping others.

 

[mrdenny]

It is entirely possible as the records which each user gets are random. If you need to avoid duplicates you'll need to log the records that each user gets and user that list as part of your filter.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog