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