With the new Common Table Expressions in SQL Server 2005 and later, it's a lot easier to get complex trees from SQL Server.

But I agree that your solution makes it a lot easier to get your trees available in code.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004

Did this post help you? Click the button to show your appreciation!