<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Ask Ben: Simple Recursion Example Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1069.view Date Posted: Dec 5, 2007 at 9:40 AM ---- --------------------------------------------------------------------------------------- ---> DECLARE @family TABLE ( id INT, name VARCHAR( 20 ), parent_id INT ); INSERT INTO @family ( id, name, parent_id )( SELECT 1, 'Micky', 0 UNION ALL SELECT 2, 'Stella', 0 UNION ALL SELECT 3, 'Arlene', 2 UNION ALL SELECT 4, 'Bruce', 1 UNION ALL SELECT 5, 'Ari', 3 UNION ALL SELECT 6, 'Erik', 3 UNION ALL SELECT 7, 'Zoe', 3 UNION ALL SELECT 8, 'Emily', 3 UNION ALL SELECT 9, 'Gabby', 6 UNION ALL SELECT 10, 'Max', 6 UNION ALL SELECT 11, 'Sophia', 5 UNION ALL SELECT 12, 'Lulu', 5 UNION ALL SELECT 13, 'Ben', 3 ); SELECT f.id, f.name, f.parent_id FROM @family f