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!