Sub-tree pruning

While preparing my talk for Teched, I figured out a trick for getting simple sub-tree pruning when running XPath queries via SqlXml. Sub-tree pruning is the ability to filter sub-trees of an Xml hierarchy. For example, let’s say I had an EmployeeList element with Employee sub elements. I would like to return the EmployeeList element, but only include Employee sub-elements where the employee had greater then 10 years of experience.

http://weblogs.asp.net/aconrad/archive/2003/06/05/56582.aspx