Hi thanks for the article.

What Windows & SQL Server version were you using?

While it won't change the functionality of anything consider altering

SELECT e1.n FROM e1, e1 x

to

SELECT e1.n

FROM e1

CROSS JOIN e1 x

As this makes it more clear a Cartesian join...

The best way to avoid any bugs is to not write any code...

Be careful what you incentivise.

I tend to roll-my-own when it comes to Hierarchies.

Here's how I do it.

Say I have a list of Employees with a Key on ID

I then make a Employee_Hierarchy table then...