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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-02 : 09:08:00
|
| Joshi Thomas writes "Hi, hopw can I select each row from employee table on a "Round Robin " basis. thanking you Joshi Thomas , Cochin" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-02 : 09:33:34
|
| "round-robin" usually implies every member paired with every other member...once....ie as in soccer matches between teams in a league....in which case you want something along the lines of...select * from emptable a inner join emptableb on 1 = 1where a.id < b.idie....effectively a cross join, minus the entries where teama plays teama.and minus the reverse fixture...(i'm using soccer terminology here...to simply things)if this is not what you want....explain YOUR idea of 'round-robin'...and/or supply sample input data and expected results.... |
 |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-07-02 : 14:20:52
|
| I am unsure what "round-robin" means but the following link may stimulate some thought or ideas:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30723 |
|
|
|
|
|
|
select each row on a round robin basis