Viewing 3 posts - 1 through 3 (of 3 total)
Tree Type Value With Leaf Id
July 1, 2014 at 2:51 am
#1726086
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...
June 30, 2014 at 4:39 am
#1725806
To get hierarchy and tree data
June 30, 2014 at 4:37 am
#1725803