Use of Recursive CTE (Common Table Expression) in a Hierarchical Table to Find Descendant Elements http://ping.fm/GsUWv(Common-Table-Expression)-in-a-Hierarchical-Table-to-Find-Descendant-Elements.aspx#.TtrpWqhzii4.pingfm