Picking random names based on condition

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Picking random names based on condition

Author

Topic

lols
Posting Yak Master

174 Posts

Posted - 2010-06-15 : 02:08:21

There is a table which contain 10 names (U1, U2, U3..and so on). I have to choose 5 names everyday, and display one as the Editor and 4 as Contributors

While selecting the random names, I have to also consider that if one user is selected as Editor, he cannot become editor again till everyone's got their turn as editor.

The output should look similar to the following:


	Editor	Cont1	Cont2	Cont3	Cont4
20-Jun 	 U1	U8	 U9	U3	U4
21-Jun	 U7	U2	U5	U6	U10
22-Jun	 U3	U4	U9	U2	U8
23-Jun   U4     U8      U3      U5      U2
and so on..

How to achieve this?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-15 : 03:28:59

duplicate post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145961

No, you're never too old to Yak'n'Roll if you're too young to die.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-06-15 : 03:29:23

Should the editor-role rotate in the sense that once a user has been an editor he cannot be an editor again for another 5 days? Or should it be completely random?

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

lols
Posting Yak Master

174 Posts

Posted - 2010-06-17 : 00:39:11

Yes he cannot be editor till everyone has got their turn..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources