SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #tTree
(
     id integer IDENTITY(1,1) NOT NULL,
     [text] varchar(256) NOT NULL,
     parentId integer NULL,
     [path] varchar(256) NOT NULL,
     depth tinyint NOT NULL,
     leaf tinyint NULL,
     expanded tinyint NULL,

     PRIMARY KEY CLUSTERED (id),
     INDEX i (parentId)
);
INSERT #tTree 
    ([text], parentId, [path], depth, leaf, expanded)
VALUES 
    ('Category 1', NULL, '1', 1, NULL, 1),
    ('SubCategory 1', 1, '1,2', 2, NULL, 1),
    ('Element 1', 2, '1,2,3', 3, 1, NULL),
    ('Category 2', NULL, '4', 1, NULL, 1),
    ('SubCategory 2', 4, '4,5', 2, 1, NULL),
    ('SubCategory 3', 4, '4,6', 2, 1, NULL),
    ('Element 2', 4, '4,7', 2, NULL, 1),
    ('SubElement 1', 5, '4,5,8', 3, 1, NULL),
    ('SubSubCategory 1', 2, '1,2,9', 3, 1, NULL),
    ('Category 3', NULL, '10', 1, 1, NULL);
10 rows affected

SELECT * FROM #tTree AS TT


id
text
parentId
path
depth
leaf
expanded


1
Category 1
null
1
1
null
1

2
SubCategory 1
1
1,2
2
null
1

3
Element 1
2
1,2,3
3
1
null

4
Category 2
null
4
1
null
1

5
SubCategory 2
4
4,5
2
1
null

6
SubCategory 3
4
4,6
2
1
null

7
Element 2
4
4,7
2
null
1

8
SubElement 1
5
4,5,8
3
1
null

9
SubSubCategory 1
2
1,2,9
3
1
null

10
Category 3
null
10
1
1
null


SET STATISTICS XML ON;

WITH R AS
(
    -- Anchor: root elements (parent is null)
    SELECT
        Roots.id,
        Roots.[path],
        Roots.children,
        element = 
        (
            SELECT Roots.*
            FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
        )
    FROM 
    (
        SELECT 
            TT.id, TT.[text], TT.[path],
            TT.depth, TT.leaf, TT.expanded,
            -- List of child IDs to resolve during recursion
            children = 
            (
                SELECT STRING_AGG(TT2.id, N',') 
                FROM #tTree AS TT2 WITH (FORCESEEK)
                WHERE TT2.parentId = TT.id
            )
        FROM #tTree AS TT 
        WHERE TT.parentId IS NULL
    ) AS Roots
    
    UNION ALL

    SELECT
        Nodes.id,
        Nodes.[path],
        Nodes.children,
        element =
        (
            -- Resolve children
            REPLACE
            (
                Nodes.element,
                -- Placeholder
                CONCAT(N'"children":"', Nodes.resolving, N'"'),
                -- Construct array of children
                CONCAT
                (
                    N'"children":',
                    (
                        SELECT 
                            TT.id, TT.[text], TT.[path], 
                            TT.depth, TT.leaf, TT.expanded,
                            Nodes.children
                        -- Split the ID list and join to child records
                        FROM STRING_SPLIT(Nodes.resolving, N',') AS SS
                        JOIN #tTree AS TT
                            WITH (FORCESEEK)
                            ON TT.id = CONVERT(integer, SS.[value])
                        FOR JSON PATH
                    )
                )
            )
        )
    FROM 
    (
        SELECT
            TT.*,
            -- Children we are resolving now
            resolving = R.children,
            R.element,
            -- New list of children to resolve later
            children = 
                STUFF
                (
                    (
                        -- Cannot use aggregates in the recurive part
                        SELECT CONCAT(N',', TT2.id) 
                        FROM #tTree AS TT2
                            WITH (FORCESEEK)
                        WHERE TT2.parentId = TT.id
                        FOR XML PATH (''), TYPE
                    ).value('(./text())[1]', 'nvarchar(4000)'),
                    1, 1, N''
                ),
            -- Any node at the same parent level will do
            -- Avoids duplicated work (see WHERE clause)
            rn = ROW_NUMBER() OVER (ORDER BY TT.parentId)
        FROM R
        JOIN #tTree AS TT
            ON TT.parentId = R.id
    ) AS Nodes
    WHERE Nodes.rn = 1
)
-- Finished nodes are those with no children
-- Concatenate and wrap as a JSON array
SELECT 
    CONCAT
    (
        N'[',
        STRING_AGG(R.element, N',')
            WITHIN GROUP (ORDER BY R.[path]),
        N']'
    )
FROM R
WHERE R.children IS NULL
OPTION (MAXRECURSION 0);


(No column name)


[{"id":1,"text":"Category 1","path":"1","depth":1,"expanded":1,"children":[{"id":2,"text":"SubCategory 1","path":"1,2","depth":2,"expanded":1,"children":[{"id":3,"text":"Element 1","path":"1,2,3","depth":3,"leaf":1},{"id":9,"text":"SubSubCategory 1","path":"1,2,9","depth":3,"leaf":1}]}]},{"id":10,"text":"Category 3","path":"10","depth":1,"leaf":1},{"id":4,"text":"Category 2","path":"4","depth":1,"expanded":1,"children":[{"id":5,"text":"SubCategory 2","path":"4,5","depth":2,"leaf":1,"children":[{"id":8,"text":"SubElement 1","path":"4,5,8","depth":3,"leaf":1}]},{"id":6,"text":"SubCategory 3","path":"4,6","depth":2,"leaf":1,"children":[{"id":8,"text":"SubElement 1","path":"4,5,8","depth":3,"leaf":1}]},{"id":7,"text":"Element 2","path":"4,7","depth":2,"expanded":1,"children":[{"id":8,"text":"SubElement 1","path":"4,5,8","depth":3,"leaf":1}]}]}]




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4053.23"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH R AS&#xd;&#xa;(&#xd;&#xa;    -- Anchor: root elements (parent is null)&#xd;&#xa;    SELECT&#xd;&#xa;        Roots.id,&#xd;&#xa;        Roots.[path],&#xd;&#xa;        Roots.children,&#xd;&#xa;        element = &#xd;&#xa;        (&#xd;&#xa;            SELECT Roots.*&#xd;&#xa;            FOR JSON PATH, WITHOUT_ARRAY_WRAPPER&#xd;&#xa;        )&#xd;&#xa;    FROM &#xd;&#xa;    (&#xd;&#xa;        SELECT &#xd;&#xa;            TT.id, TT.[text], TT.[path],&#xd;&#xa;            TT.depth, TT.leaf, TT.expanded,&#xd;&#xa;            -- List of child IDs to resolve during recursion&#xd;&#xa;            children = &#xd;&#xa;            (&#xd;&#xa;                SELECT STRING_AGG(TT2.id, N&apos;,&apos;) &#xd;&#xa;                FROM #tTree AS TT2 WITH (FORCESEEK)&#xd;&#xa;                WHERE TT2.parentId = TT.id&#xd;&#xa;            )&#xd;&#xa;        FROM #tTree AS TT &#xd;&#xa;        WHERE TT.parentId IS NULL&#xd;&#xa;    ) AS Roots&#xd;&#xa;    &#xd;&#xa;    UNION ALL&#xd;&#xa;&#xd;&#xa;    SELECT&#xd;&#xa;        Nodes.id,&#xd;&#xa;        Nodes.[path],&#xd;&#xa;        Nodes.children,&#xd;&#xa;        element =&#xd;&#xa;        (&#xd;&#xa;            -- Resolve children&#xd;&#xa;            REPLACE&#xd;&#xa;            (&#xd;&#xa;                Nodes.element,&#xd;&#xa;                -- Placeholder&#xd;&#xa;                CONCAT(N&apos;&quot;children&quot;:&quot;&apos;, Nodes.resolving, N&apos;&quot;&apos;),&#xd;&#xa;                -- Construct array of children&#xd;&#xa;                CONCAT&#xd;&#xa;                (&#xd;&#xa;                    N&apos;&quot;children&quot;:&apos;,&#xd;&#xa;                    (&#xd;&#xa;                        SELECT &#xd;&#xa;                            TT.id, TT.[text], TT.[path], &#xd;&#xa;                            TT.depth, TT.leaf, TT.expanded,&#xd;&#xa;                            Nodes.children&#xd;&#xa;                        -- Split the ID list and join to child records&#xd;&#xa;                        FROM STRING_SPLIT(Nodes.resolving, N&apos;,&apos;) AS SS&#xd;&#xa;                        JOIN #tTree AS TT&#xd;&#xa;                            WITH (FORCESEEK)&#xd;&#xa;                            ON TT.id = CONVERT(integer, SS.[value])&#xd;&#xa;                        FOR JSON PATH&#xd;&#xa;                    )&#xd;&#xa;                )&#xd;&#xa;            )&#xd;&#xa;        )&#xd;&#xa;    FROM &#xd;&#xa;    (&#xd;&#xa;        SELECT&#xd;&#xa;            TT.*,&#xd;&#xa;            -- Children we are resolving now&#xd;&#xa;            resolving = R.children,&#xd;&#xa;            R.element,&#xd;&#xa;            -- New list of children to resolve later&#xd;&#xa;            children = &#xd;&#xa;                STUFF&#xd;&#xa;                (&#xd;&#xa;                    (&#xd;&#xa;                        -- Cannot use aggregates in the recurive part&#xd;&#xa;                        SELECT CONCAT(N&apos;,&apos;, TT2.id) &#xd;&#xa;                        FROM #tTree AS TT2&#xd;&#xa;                            WITH (FORCESEEK)&#xd;&#xa;                        WHERE TT2.parentId = TT.id&#xd;&#xa;                        FOR XML PATH (&apos;&apos;), TYPE&#xd;&#xa;                    ).value(&apos;(./text())[1]&apos;, &apos;nvarchar(4000)&apos;),&#xd;&#xa;                    1, 1, N&apos;&apos;&#xd;&#xa;                ),&#xd;&#xa;            -- Any node at the same parent level will do&#xd;&#xa;            -- Avoids duplicated work (see WHERE clause)&#xd;&#xa;            rn = ROW_NUMBER() OVER (ORDER BY TT.parentId)&#xd;&#xa;        FROM R&#xd;&#xa;        JOIN #tTree AS TT&#xd;&#xa;            ON TT.parentId = R.id&#xd;&#xa;    ) AS Nodes&#xd;&#xa;    WHERE Nodes.rn = 1&#xd;&#xa;)&#xd;&#xa;-- Finished nodes are those with no children&#xd;&#xa;-- Concatenate and wrap as a JSON array&#xd;&#xa;SELECT &#xd;&#xa;    CONCAT&#xd;&#xa;    (&#xd;&#xa;        N&apos;[&apos;,&#xd;&#xa;        STRING_AGG(R.element, N&apos;,&apos;)&#xd;&#xa;            WITHIN GROUP (ORDER BY R.[path]),&#xd;&#xa;        N&apos;]&apos;&#xd;&#xa;    )&#xd;&#xa;FROM R&#xd;&#xa;WHERE R.children IS NULL&#xd;&#xa;OPTION (MAXRECURSION 0)" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.244986" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x302905E3DE7ECB63" QueryPlanHash="0x67093DFCF6BF2AB8" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="150"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="120" CompileTime="15" CompileCPU="15" CompileMemory="1504"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[TT2].[id],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[TT2].[id],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(4000),XML Reader with XPath filter.[lvalue],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(4000),XML Reader with XPath filter.[value],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(int,STRING_SPLIT.[value],0)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="560" RequiredMemory="512" DesiredMemory="560" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="881600" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="838808" EstimatedPagesCached="52425" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2026872"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2022-07-25T16:08:53.57" ModificationCount="0" SamplingPercent="100" Statistics="[i]" Table="[#tTree______________________________________________________________________________________________________________000000000459]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.244986" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1034"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference><ScalarOperator ScalarString="concat(CONVERT_IMPLICIT(nvarchar(max),N&apos;[&apos;,0),[Expr1033],CONVERT_IMPLICIT(nvarchar(max),N&apos;]&apos;,0))"><Intrinsic FunctionName="concat"><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="N&apos;[&apos;"></Const></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1033"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="N&apos;]&apos;"></Const></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.22337e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.244986" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1033"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([Recr1032],N&apos;,&apos;)WITHIN GROUP (ORDER BY [Recr1030])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Column="Recr1032"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;,&apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2.87228" EstimateIO="0.0112613" EstimateCPU="0.000110986" AvgRowSize="4165" EstimatedTotalSubtreeCost="0.244984" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1030"></ColumnReference><ColumnReference Column="Recr1032"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Recr1030"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="2.87228" EstimateIO="0" EstimateCPU="3.96e-06" AvgRowSize="4165" EstimatedTotalSubtreeCost="0.233612" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1030"></ColumnReference><ColumnReference Column="Recr1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="4" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="8.25" EstimateIO="0" EstimateCPU="2.375e-08" AvgRowSize="8167" EstimatedTotalSubtreeCost="0.233608" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="Recr1030"></ColumnReference><ColumnReference Column="Recr1031"></ColumnReference><ColumnReference Column="Recr1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="15" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool Stack="1"><RelOp NodeId="5" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="8.25" EstimateIO="0" EstimateCPU="4.75e-09" AvgRowSize="8167" EstimatedTotalSubtreeCost="0.210125" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="Recr1030"></ColumnReference><ColumnReference Column="Recr1031"></ColumnReference><ColumnReference Column="Recr1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1040"></ColumnReference><ColumnReference Column="Expr1042"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1030"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1031"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1032"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8167" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1040"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1040"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="8171" EstimatedTotalSubtreeCost="0.00693659" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="8171" EstimatedTotalSubtreeCost="0.00693629" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OuterReferences><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="4278" EstimatedTotalSubtreeCost="0.00691759" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="[Expr1002]"><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="4278" EstimatedTotalSubtreeCost="0.00691729" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="11" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="3" EstimatedRowsRead="10" EstimateIO="0.003125" EstimateCPU="0.000168" AvgRowSize="280" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[PK__#tTree____3213E83FA7129F85]" Alias="[TT]" TableReferenceId="1" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="#tTree.[parentId] as [TT].[parentId] IS NULL"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="parentId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.55e-06" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.00360695" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="STRING_AGG([Expr1036],N&apos;,&apos;)"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Identifier><ColumnReference Column="Expr1036"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;,&apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0036023" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1036"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1036"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(12),#tTree.[id] as [TT2].[id],0)"><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.75" EstimatedRowsRead="1.75" EstimateIO="0.003125" EstimateCPU="0.000158925" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00360178" TableCardinality="10" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[i]" Alias="[TT2]" TableReferenceId="1" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[TT2]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="#tTree.[id] as [TT].[id]"><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp><RelOp NodeId="15" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="6.157e-06" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR JSON"><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></UsedUDXColumns><RelOp NodeId="16" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="3.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></Extension></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="2.75" EstimateIO="0" EstimateCPU="3.99e-07" AvgRowSize="8167" EstimatedTotalSubtreeCost="0.203188" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference></OuterReferences><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8167" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1042"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1042"></ColumnReference><ScalarOperator ScalarString="[Expr1041]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1041"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="4.75e-08" AvgRowSize="8167" EstimatedTotalSubtreeCost="4.75e-08" Parallel="0" EstimateRebinds="8.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference><ColumnReference Column="Recr1008"></ColumnReference><ColumnReference Column="Recr1009"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="4" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="20" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="8171" EstimatedTotalSubtreeCost="0.203188" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1028"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1028"></ColumnReference><ScalarOperator ScalarString="replace([Recr1011],concat(N&apos;&quot;children&quot;:&quot;&apos;,[Recr1010],N&apos;&quot;&apos;),concat(CONVERT_IMPLICIT(nvarchar(max),N&apos;&quot;children&quot;:&apos;,0),[Expr1026]))"><Intrinsic FunctionName="replace"><ScalarOperator><Identifier><ColumnReference Column="Recr1011"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Const ConstValue="N&apos;&quot;children&quot;:&quot;&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;&quot;&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1035"><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Const ConstValue="N&apos;&quot;children&quot;:&apos;"></Const></ScalarOperator></Convert></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.75" EstimateIO="0" EstimateCPU="7.315e-06" AvgRowSize="8171" EstimatedTotalSubtreeCost="0.203186" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference><ColumnReference Column="Expr1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="7" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1024"></ColumnReference></OuterReferences><RelOp NodeId="22" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="4145" EstimatedTotalSubtreeCost="0.0820465" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="stuff([Expr1023],(1),(1),N&apos;&apos;)"><Intrinsic FunctionName="stuff"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.75" EstimateIO="0" EstimateCPU="7.315e-06" AvgRowSize="4145" EstimatedTotalSubtreeCost="0.0820451" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="7" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="24" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1.75" EstimateIO="0" EstimateCPU="8.4e-07" AvgRowSize="143" EstimatedTotalSubtreeCost="0.00399129" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="7" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="25" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="151" EstimatedTotalSubtreeCost="0.00398436" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="7" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="CASE WHEN (1) IS NULL OR (1)&lt;(0) THEN (0) ELSE (1) END"><IF><Condition><ScalarOperator><Logical Operation="OR"><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></TopExpression><RelOp NodeId="26" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.4e-07" AvgRowSize="151" EstimatedTotalSubtreeCost="0.00398292" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="27" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="1.75" EstimateIO="0" EstimateCPU="3.5e-08" AvgRowSize="151" EstimatedTotalSubtreeCost="0.00395008" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Column="Segment1039"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1039"></ColumnReference></SegmentColumn><RelOp NodeId="28" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1.75" EstimatedRowsRead="10" EstimateIO="0.0032035" EstimateCPU="8.95e-05" AvgRowSize="147" EstimatedTotalSubtreeCost="0.00394188" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="7.25" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="15" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="48" ActualEndOfScans="3" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[PK__#tTree____3213E83FA7129F85]" Alias="[TT]" TableReferenceId="2" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="#tTree.[parentId] as [TT].[parentId]=[Recr1008]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="parentId"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1008"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></Segment></RelOp></SequenceProject></RelOp></Top></RelOp><Predicate><ScalarOperator ScalarString="[Expr1013]=(1)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="29" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.0779934" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1017"></ColumnReference></OuterReferences><RelOp NodeId="30" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.00543789" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1017"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="[Expr1016]"><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="31" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.00543644" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1016"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR XML"><DefinedValues><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Column="Expr1015"></ColumnReference></UsedUDXColumns><RelOp NodeId="32" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.75" EstimateIO="0" EstimateCPU="1.75e-07" AvgRowSize="24" EstimatedTotalSubtreeCost="0.00542201" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1015"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="concat(N&apos;,&apos;,CONVERT_IMPLICIT(nvarchar(12),#tTree.[id] as [TT2].[id],0))"><Intrinsic FunctionName="concat"><ScalarOperator><Const ConstValue="N&apos;,&apos;"></Const></ScalarOperator><ScalarOperator><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="33" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.75" EstimatedRowsRead="1.75" EstimateIO="0.003125" EstimateCPU="0.000158925" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00541948" TableCardinality="10" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="4" ActualLogicalReads="8" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT2]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[i]" Alias="[TT2]" TableReferenceId="2" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[TT2]" Column="parentId"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="#tTree.[id] as [TT].[id]"><Identifier><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp></Extension></RelOp></ComputeScalar></RelOp><RelOp NodeId="34" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.0724952" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="MIN(CASE WHEN [Expr1017] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])&gt;=(128) THEN CONVERT_IMPLICIT(nvarchar(4000),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(nvarchar(4000),XML Reader with XPath filter.[value],0) END END)"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Then><Else><ScalarOperator><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="35" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0724793" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="36" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateRowsWithoutRowGoal="200" EstimateIO="0" EstimateCPU="2e-05" AvgRowSize="8949" EstimatedTotalSubtreeCost="0.0724779" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="37" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="1" EstimateRowsWithoutRowGoal="200" EstimateIO="0" EstimateCPU="1.004" AvgRowSize="8497" EstimatedTotalSubtreeCost="0.0724764" Parallel="0" EstimateRebinds="13.4375" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="4" ActualRewinds="0" ActualEndOfScans="2" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[Expr1017]"><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp></ComputeScalar></RelOp></Top></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp><RelOp NodeId="38" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.12108" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="6.1875" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR JSON"><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></UsedUDXColumns><RelOp NodeId="39" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="50" EstimateIO="0" EstimateCPU="0.000209" AvgRowSize="276" EstimatedTotalSubtreeCost="0.121065" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="6.1875" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1037"></ColumnReference></OuterReferences><RelOp NodeId="40" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="50" EstimateIO="0" EstimateCPU="5e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="0.000794219" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="6.1875" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1037"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1037"></ColumnReference><ScalarOperator ScalarString="CONVERT(int,STRING_SPLIT.[value],0)"><Convert DataType="int" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Table="[STRING_SPLIT]" Column="value"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="41" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="50" EstimateIO="0" EstimateCPU="5.0157e-05" AvgRowSize="4011" EstimatedTotalSubtreeCost="0.000722032" Parallel="0" EstimateRebinds="7.25" EstimateRewinds="6.1875" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[STRING_SPLIT]" Column="value"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="4" ActualRewinds="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[STRING_SPLIT]" Column="value"></ColumnReference></DefinedValue></DefinedValues><Object Table="[STRING_SPLIT]"></Object><ParameterList><ScalarOperator ScalarString="[Recr1010]"><Identifier><ColumnReference Column="Recr1010"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="N&apos;,&apos;"><Const ConstValue="N&apos;,&apos;"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp></ComputeScalar></RelOp><RelOp NodeId="42" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="276" EstimatedTotalSubtreeCost="0.117253" TableCardinality="10" Parallel="0" EstimateRebinds="633.224" EstimateRewinds="87.651" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="14" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="7" ActualEndOfScans="0" ActualExecutions="7"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="text"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="path"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="depth"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="leaf"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tTree" Alias="[TT]" Column="expanded"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tTree]" Index="[PK__#tTree____3213E83FA7129F85]" Alias="[TT]" TableReferenceId="3" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tTree" Alias="[TT]" Column="id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Expr1037]"><Identifier><ColumnReference Column="Expr1037"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></Extension></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp></Concat></RelOp></Spool></RelOp><Predicate><ScalarOperator ScalarString="[Recr1031] IS NULL"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Recr1031"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
id	text	parentId	path	depth	leaf	expanded
1	Category 1	null	1	1	null	1
2	SubCategory 1	1	1,2	2	null	1
3	Element 1	2	1,2,3	3	1	null
4	Category 2	null	4	1	null	1
5	SubCategory 2	4	4,5	2	1	null
6	SubCategory 3	4	4,6	2	1	null
7	Element 2	4	4,7	2	null	1
8	SubElement 1	5	4,5,8	3	1	null
9	SubSubCategory 1	2	1,2,9	3	1	null
10	Category 3	null	10	1	1	null