Got linked in!
What is your excuse now?
Which is the best DN site?
Citibank defines advanced browsers
Freeware for HTML editing on Windows
In no particular order.
CONNECT BY isn't around - DocQueryInSql, TreeInSql, Storing hierarchical dataI totally agree about Foobar2000. Amazing application that does what it is meant to do, well. Right now I am having fun tweaking the playlist srtyle :)
The book "Advanced Transact-SQL for SQL Server 2000" by Itzik Ben-Gan & Tom Moreau has a chapter dedicated to trees (chapter 16). While the examples are written in T-SQL, geared specifically for SQL-Server, they could be applied to other database servers with minimal changes. They're using a technique similar to the TreeInSql page, and adding triggers to the mix to automatically keep the path up to date. Fun stuff.