In my first blog post I will explain Common Table Expressions (CTEs) in T-SQL queries and the powerful feature of recursive CTEs, i.e., CTEs that reference themselves. The game of darts provides a great example to illustrate these concepts. When two players play a game (leg) of darts, the purpose is...