tafinami (6/30/2014)

---

DECLARE c CURSOR READ_ONLY FAST_FORWARD FOR

SELECT Id FROM Tree_Table WHERE Id NOT IN (SELECT DISTINCT ParentId FROM Tree_Table WHERE ParentId IS NOT NULL)

DECLARE @IdPk INT

OPEN c

FETCH NEXT FROM c INTO @IdPk

WHILE (@@FETCH_STATUS = 0)

BEGIN

DECLARE @NodeValue VARCHAR(MAX)

SET @NodeValue = ''

WHILE(EXISTS(SELECT * FROM Tree_Table WHERE Id=@IdPk))

BEGIN

SELECT @NodeValue=Name+'/'+@NodeValue,

@IdPk=ParentId

FROM Tree_Table

WHERE id=@IdPk

END

PRINT 'Parent to Leaf: ' + LEFT(@NodeValue,LEN(@NodeValue)-1)

FETCH NEXT FROM c INTO @IdPk

END

CLOSE c

DEALLOCATE c

To get hierarchy and tree view data