TRY This.

DECLARE @t TABLE

(

Node int null,

Parent int null

)

INSERT @t (Node,Parent)

SELECT 1,null UNION ALL

SELECT 2, 1 UNION ALL

SELECT 3, 1 UNION ALL

SELECT 4, 1 UNION ALL

SELECT 5, 1 UNION ALL

SELECT 5,...