jts_2003 (9/29/2010)
2. You can build a recursive CTE - although I'm no sure I would want to 😉
Recursive CTE'sare an invaluable tool when working with hierarchic data (like employee/supervisor relations, parts built of parts built of parts, genealogy data, etc). There are some examples of this in Books Online.