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