Graphs, Trees, Hierarchies and Itzik

As being the guest author on Itzik Ben Gan’s Inside MS SQL Server 2005: T-SQL Querying book, this blog might seem boasting to you. However, I did not write anything in the chapter 9 – Graphs, Trees, Hierarchies and Recursive Queries, and I am talking about this chapter. In a single day, I used the following solutions from the chapter:

–          a tree;

–          a directed acyclic graph;

–          a undirected cyclic weighted graph;

–          path enumerations;

–          materialized path;

–          transitive closure of the undirected cyclic weighted graph;

–          all kinds of queries from the chapter.

I never used so much code and examples from a book directly in a project. This saved me days of work. Thanks, Yatz!