Single-query solution to TC81, Round-Robing Tournament Scheduling

This uses a slight modification of the "Diagonal Scheme" approach to Round-Robin scheduling. The Teams table is cross-joined with itself (within the same leagues), eliminating cases of teams playing themselves. Then the "Diagonal Scheme" is used, convers

Does the output need to be ordered by (LeagueID, Round, HomeTeam) ?

Jeff said ... I agree with everything you said about sets (heh... you should write a book on sets) but not when it comes to the way triangular joins are typically used and what they must do behind the scenes. I do, however, agree that a triangula

Barry said... _____________________________________________________ ...the reason why is that the "Sets" of SQL are tables and rowsets, and what constitutes their members (or "elements" in Set Theory) is *not* individual data values or even columns,

Jeff said... _____________________________________________________ ...How many times can a single instance of a single thing exist in a single set, Barry? Triangular joins read each row more than once and are not set based... ____________________

Jeff said... _____________________________________________________ ...Consider this... you good folks do allow recursive CTE's and they are patently not set based any more than a nice "Triangular Join" is... _______________________________________

All you have to do is cast the Varbinary() back to Varchar(). I do it all the time for ServiceBroker: SELECT CAST(@x as Varchar(MAX)) ...

All you have to do is cast the Varbinary() back to Varchar(). I do it all the time for ServiceBroker: SELECT CAST(@x as Varchar(MAX)) ...