Home Forums SQL Server 2014 Development - SQL Server 2014 Hierarchical order by TSQL RE: Hierarchical order by TSQL

  • February 7, 2014 at 5:04 am

    #1686980

    Dear Sir

    The above query produces the required result even though 101 not appear in the parent Id since it is top level parent.

    PIDCID

    16

    output :1/6

    16

    output : 101/1/6

    Many Thanks Experts.