Simple SQL stuff: Hierarchies in SQL Server
One of my favorite subjects, hierarchical data :-)
I thought to blog that I posted a while ago on ASP.NET Forums about dealing with a self-joining table on SQL Server, when you'd want to iterate from child rows to the parent rows e.g locate parent(s) of a given row (bottom-up). It's just simple recursive stuff, but useful one.
Hope it helps anyone : http://forums.asp.net/1071023/ShowPost.aspx
P.S I blogged some time ago about the opposite approach e.g expanding hierarchies (recursive top-down approach). http://aspadvice.com/blogs/joteke/archive/2005/05/19/2331.aspx