TSQL Challenge 81 - Create a Game schedule generator in TSQL
This challenge is to generate a game scheduler based on the Teams given in a table. The key point is each Team has to play with other team in one round of game.
http://beyondrelational.com/puzzles/challenges/115/create-a-game-schedule-generator-in-tsql.aspx