This email was created by [your name] who thought you would be interested in the following Article:
"T- SQL - How to get all descendants of a given element in a hierarchical table"
This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!