Tag:FullPath

  • FullPath of SQL SERVER 2008 CTE Generation Node

    Time:2019-9-10

    Okay, now let’s see how to generate FullPath: Copy codeThe code is as follows: DECLARE @tbl TABLE ( Id int ,ParentId int ) INSERT INTO @tbl ( Id, ParentId ) VALUES ( 0, NULL ) , ( 8, 0 ) , ( 12, 8 ) , ( 16, 12 ) , ( 17, 16 ) […]