SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.property 
(
    propertyID integer NOT NULL,
    parentID integer NULL,
    title nvarchar(100) NOT NULL,
    typeid integer NOT NULL,
    [value] nvarchar(1000) NOT NULL

    CONSTRAINT PK_dbo_property__propertyID
        PRIMARY KEY NONCLUSTERED (propertyID),

    INDEX IX_dbo_property__parentID 
        CLUSTERED (parentID)
);
INSERT dbo.property 
    (propertyID, parentID, title, typeid, [value]) 
VALUES
    (1,0,'foo',150, 'bar'),
    (2,0,'foo',128, 'bar'),
    (3,0,'foo',128, 'bar'),
    (4,3,'foo',128, 'bar'),
    (5,3,'foo',128, 'bar'),
    (6,3,'foo',128, 'bar'),
    (7,6,'foo',128, 'bar'),
    (8,7,'foo',128, 'bar'),
    (9,8,'foo',128, 'bar'),
    (10,9,'foo',128, 'bar'),
    (41,4,'foo',128, 'bar'),
    (42,4,'foo',128, 'bar'),
    (421,42,'foo',128, 'bar'),
    (411,41,'foo',128, 'bar');
14 rows affected

SET STATISTICS XML ON;

WITH 
    Recursion AS
    (
        -- Anchor part
        SELECT 
            P.propertyID, 
            depth = 1,
            rpath = CONVERT(nvarchar(4000), P.propertyID),
            has_children = 
                IIF
                (
                    EXISTS
                    (
                        SELECT C.* 
                        FROM dbo.property AS C 
                        WHERE C.parentId = P.propertyID
                    ), 
                    1, 0
                ),
            element = 
                (
                    SELECT P.propertyID, P.title, P.typeid, P.[value] 
                    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
                )
        FROM dbo.property AS P
        WHERE P.parentID = 0

        UNION ALL 

        -- Recursive part
        SELECT
            P.propertyID,
            depth = R.depth + 1,
            rpath = CONCAT_WS(N'.', R.rpath, P.propertyID),
            has_children = 
                IIF
                (
                    EXISTS
                    (
                        SELECT C.* 
                        FROM dbo.property AS C 
                        WHERE C.parentId = P.propertyID
                    ), 
                    1, 0
                ),
            element = 
                (
                    SELECT P.propertyID, P.title, P.typeid, P.[value] 
                    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
                )
        FROM Recursion AS R
        JOIN dbo.property AS P
            WITH (FORCESEEK)
            ON P.parentID = R.propertyID
    ),
    AddNextDepth AS
    (
        SELECT
            R.*,
            NextDepth = 
                LEAD(R.depth) OVER (
                    ORDER BY R.rpath)
        FROM Recursion AS R
    ),
    ModifiedTree AS
    (
        SELECT 
            ND.rpath, 
            element =
                CONCAT
                (
                    -- Insert "children" element
                    IIF
                    (
                        -- No children, add empty array
                        ND.has_children = 0,
                        STUFF
                        (
                            ND.element,
                            LEN(ND.element),
                            0,
                            N',"children":[{}]'
                        ),
                        -- Insert "children" element
                        STUFF
                        (
                            ND.element,
                            LEN(ND.element),
                            1,
                            N',"children":['
                        )
                    ),
                    -- Close previously opened array(s) if necessary
                    REPLICATE
                    (
                        N']}', 
                        -- Number of closures needed
                        ND.depth - ISNULL(ND.NextDepth, 1)
                    ),
                    -- Add comma if no children and not the last line
                    IIF
                    (
                        ND.has_children = 0 
                            AND ND.NextDepth IS NOT NULL, 
                        N',', 
                        N''
                    )
                )
        FROM AddNextDepth AS ND
    )
-- Concatenate objects in path order and add array wrapper
SELECT
    CONCAT
    (
        N'[',
        STRING_AGG(MT.element, N'') 
            WITHIN GROUP (ORDER BY MT.rpath),
        N']'
    )
FROM ModifiedTree AS MT;


(No column name)


[{"propertyID":1,"title":"foo","typeid":150,"value":"bar","children":[{}]},{"propertyID":2,"title":"foo","typeid":128,"value":"bar","children":[{}]},{"propertyID":3,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":4,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":41,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":411,"title":"foo","typeid":128,"value":"bar","children":[{}]}]},{"propertyID":42,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":421,"title":"foo","typeid":128,"value":"bar","children":[{}]}]}]},{"propertyID":5,"title":"foo","typeid":128,"value":"bar","children":[{}]},{"propertyID":6,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":7,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":8,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":9,"title":"foo","typeid":128,"value":"bar","children":[{"propertyID":10,"title":"foo","typeid":128,"value":"bar","children":[{}]}]}]}]}]}]}]




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.539" Build="15.0.4223.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH &#xa;    Recursion AS&#xa;    (&#xa;        -- Anchor part&#xa;        SELECT &#xa;            P.propertyID, &#xa;            depth = 1,&#xa;            rpath = CONVERT(nvarchar(4000), P.propertyID),&#xa;            has_children = &#xa;                IIF&#xa;                (&#xa;                    EXISTS&#xa;                    (&#xa;                        SELECT C.* &#xa;                        FROM dbo.property AS C &#xa;                        WHERE C.parentId = P.propertyID&#xa;                    ), &#xa;                    1, 0&#xa;                ),&#xa;            element = &#xa;                (&#xa;                    SELECT P.propertyID, P.title, P.typeid, P.[value] &#xa;                    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER&#xa;                )&#xa;        FROM dbo.property AS P&#xa;        WHERE P.parentID = 0&#xa;&#xa;        UNION ALL &#xa;&#xa;        -- Recursive part&#xa;        SELECT&#xa;            P.propertyID,&#xa;            depth = R.depth + 1,&#xa;            rpath = CONCAT_WS(N&apos;.&apos;, R.rpath, P.propertyID),&#xa;            has_children = &#xa;                IIF&#xa;                (&#xa;                    EXISTS&#xa;                    (&#xa;                        SELECT C.* &#xa;                        FROM dbo.property AS C &#xa;                        WHERE C.parentId = P.propertyID&#xa;                    ), &#xa;                    1, 0&#xa;                ),&#xa;            element = &#xa;                (&#xa;                    SELECT P.propertyID, P.title, P.typeid, P.[value] &#xa;                    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER&#xa;                )&#xa;        FROM Recursion AS R&#xa;        JOIN dbo.property AS P&#xa;            WITH (FORCESEEK)&#xa;            ON P.parentID = R.propertyID&#xa;    ),&#xa;    AddNextDepth AS&#xa;    (&#xa;        SELECT&#xa;            R.*,&#xa;            NextDepth = &#xa;                LEAD(R.depth) OVER (&#xa;                    ORDER BY R.rpath)&#xa;        FROM Recursion AS R&#xa;    ),&#xa;    ModifiedTree AS&#xa;    (&#xa;        SELECT &#xa;            ND.rpath, &#xa;            element =&#xa;                CONCAT&#xa;                (&#xa;                    -- Insert &quot;children&quot; element&#xa;                    IIF&#xa;                    (&#xa;                        -- No children, add empty array&#xa;                        ND.has_children = 0,&#xa;                        STUFF&#xa;                        (&#xa;                            ND.element,&#xa;                            LEN(ND.element),&#xa;                            0,&#xa;                            N&apos;,&quot;children&quot;:[{}]&apos;&#xa;                        ),&#xa;                        -- Insert &quot;children&quot; element&#xa;                        STUFF&#xa;                        (&#xa;                            ND.element,&#xa;                            LEN(ND.element),&#xa;                            1,&#xa;                            N&apos;,&quot;children&quot;:[&apos;&#xa;                        )&#xa;                    ),&#xa;                    -- Close previously opened array(s) if necessary&#xa;                    REPLICATE&#xa;                    (&#xa;                        N&apos;]}&apos;, &#xa;                        -- Number of closures needed&#xa;                        ND.depth - ISNULL(ND.NextDepth, 1)&#xa;                    ),&#xa;                    -- Add comma if no children and not the last line&#xa;                    IIF&#xa;                    (&#xa;                        ND.has_children = 0 &#xa;                            AND ND.NextDepth IS NOT NULL, &#xa;                        N&apos;,&apos;, &#xa;                        N&apos;&apos;&#xa;                    )&#xa;                )&#xa;        FROM AddNextDepth AS ND&#xa;    )&#xa;-- Concatenate objects in path order and add array wrapper&#xa;SELECT&#xa;    CONCAT&#xa;    (&#xa;        N&apos;[&apos;,&#xa;        STRING_AGG(MT.element, N&apos;&apos;) &#xa;            WITHIN GROUP (ORDER BY MT.rpath),&#xa;        N&apos;]&apos;&#xa;    )&#xa;FROM ModifiedTree AS MT" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0282516" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x92D3A2084F796208" QueryPlanHash="0xF1511197446A7F09" 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="112" CompileTime="187" CompileCPU="15" CompileMemory="1112"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT(nvarchar(4000),[P].[propertyID],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(12),[P].[propertyID],0)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="656" RequiredMemory="512" DesiredMemory="656" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="744064" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2792320"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2025-06-16T11:17:54.48" ModificationCount="0" SamplingPercent="100" Statistics="[PK_dbo_property__propertyID]" Table="[property]" Schema="[dbo]" Database="[fiddle_d4bf163509014d38a599e3fd37672108]"></StatisticsInfo><StatisticsInfo LastUpdate="2025-06-16T11:17:54.47" ModificationCount="0" SamplingPercent="100" Statistics="[IX_dbo_property__parentID]" Table="[property]" Schema="[dbo]" Database="[fiddle_d4bf163509014d38a599e3fd37672108]"></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="15" CpuTime="15"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0282516" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1033"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1033"></ColumnReference><ScalarOperator ScalarString="concat(CONVERT_IMPLICIT(nvarchar(max),N&apos;[&apos;,0),[Expr1032],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="Expr1032"></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="5.1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0282515" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1032"></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="Expr1032"></ColumnReference><ScalarOperator ScalarString="STRING_AGG(concat(CASE WHEN [Recr1028]=(0) THEN stuff([Recr1029],len([Recr1029]),(0),N&apos;,&quot;children&quot;:[{}]&apos;) ELSE stuff([Recr1029],len([Recr1029]),(1),N&apos;,&quot;children&quot;:[&apos;) END,CONVERT_IMPLICIT(nvarchar(max),replicate(N&apos;]}&apos;,[Recr1026]-isnull([Expr1030],(1))),0),CONVERT_IMPLICIT(nvarchar(max),CASE WHEN [Recr1028]=(0) AND [Expr1030] IS NOT NULL THEN N&apos;,&apos; ELSE N&apos;&apos; END,0)),N&apos;&apos;)WITHIN GROUP (ORDER BY [Recr1027])"><Aggregate Distinct="0" AggType="STRING_AGG"><ScalarOperator><Intrinsic FunctionName="concat"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Recr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Intrinsic FunctionName="stuff"><ScalarOperator><Identifier><ColumnReference Column="Recr1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="len"><ScalarOperator><Identifier><ColumnReference Column="Recr1029"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;,&quot;children&quot;:[{}]&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Then><Else><ScalarOperator><Intrinsic FunctionName="stuff"><ScalarOperator><Identifier><ColumnReference Column="Recr1029"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="len"><ScalarOperator><Identifier><ColumnReference Column="Recr1029"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;,&quot;children&quot;:[&apos;"></Const></ScalarOperator></Intrinsic></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="replicate"><ScalarOperator><Const ConstValue="N&apos;]}&apos;"></Const></ScalarOperator><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="Recr1026"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="isnull"><ScalarOperator><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Arithmetic></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Recr1028"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Column="Expr1030"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="N&apos;,&apos;"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="N&apos;&apos;"></Const></ScalarOperator></Else></IF></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;&apos;"></Const></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="4.81467e-06" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.0282464" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="Expr1030"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1030"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE([Recr1026])"><Aggregate Distinct="0" AggType="LAST_VALUE"><ScalarOperator><Identifier><ColumnReference Column="Recr1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1026"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1026])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1026"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1027"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1027])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1027"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1028"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1028])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1028"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Recr1029"></ColumnReference><ScalarOperator ScalarString="ANY([Recr1029])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Recr1029"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1049"></ColumnReference></GroupBy><RelOp NodeId="3" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="15.3333" EstimateIO="0" EstimateCPU="1.68513e-05" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.0282416" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="RowNumber1037"></ColumnReference><ColumnReference Column="WindowCount1049"></ColumnReference><ColumnReference Column="Segment1048"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="27" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="4.81467e-07" AvgRowSize="8077" EstimatedTotalSubtreeCost="0.0282228" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="RowNumber1037"></ColumnReference><ColumnReference Column="TopRowNumber1038"></ColumnReference><ColumnReference Column="BottomRowNumber1039"></ColumnReference><ColumnReference Column="Segment1048"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1048"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="7.66667e-07" AvgRowSize="8069" EstimatedTotalSubtreeCost="0.0282223" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="RowNumber1037"></ColumnReference><ColumnReference Column="TopRowNumber1038"></ColumnReference><ColumnReference Column="BottomRowNumber1039"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="TopRowNumber1038"></ColumnReference><ScalarOperator ScalarString="[RowNumber1037]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="BottomRowNumber1039"></ColumnReference><ScalarOperator ScalarString="[RowNumber1037]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1037"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="6.13333e-07" AvgRowSize="8053" EstimatedTotalSubtreeCost="0.0282216" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="RowNumber1037"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1037"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="1.53333e-07" AvgRowSize="8053" EstimatedTotalSubtreeCost="0.0282209" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="Segment1047"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1047"></ColumnReference></SegmentColumn><RelOp NodeId="8" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="7.66667" EstimateIO="0.0112613" EstimateCPU="0.000143191" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0282208" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" 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="Recr1027"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="9" PhysicalOp="Index Spool" LogicalOp="Lazy Spool" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="2.27778e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0168163" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="29" 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="10" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="7.66667" EstimateIO="0" EstimateCPU="4.55556e-09" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0163952" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Recr1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Expr1046"></ColumnReference><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Column="Expr1045"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1025"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1026"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1027"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1028"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Recr1029"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.55556e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.55556e-08" Parallel="0" EstimateRebinds="7.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1043"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1043"></ColumnReference><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="8049" EstimatedTotalSubtreeCost="0.00691644" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1034] THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1034"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1007]"><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="8042" EstimatedTotalSubtreeCost="0.00691614" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1034"></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 Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></OuterReferences><RelOp NodeId="14" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-05" AvgRowSize="5124" EstimatedTotalSubtreeCost="0.00689744" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1034"></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"><DefinedValues><DefinedValue><ColumnReference Column="Expr1034"></ColumnReference></DefinedValue></DefinedValues><OuterReferences><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></OuterReferences><ProbeColumn><ColumnReference Column="Expr1034"></ColumnReference></ProbeColumn><RelOp NodeId="15" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="5123" EstimatedTotalSubtreeCost="0.0032856" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT(nvarchar(4000),[fiddle_d4bf163509014d38a599e3fd37672108].[dbo].[property].[propertyID] as [P].[propertyID],0)"><Convert DataType="nvarchar" Length="8000" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="1121" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></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="3" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Index="[IX_dbo_property__parentID]" Alias="[P]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="parentID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="17" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="1.55556" EstimatedRowsRead="1.55556" EstimateIO="0.003125" EstimateCPU="0.000158711" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0035993" TableCardinality="14" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="2" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Index="[IX_dbo_property__parentID]" Alias="[C]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[C]" Column="parentID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_d4bf163509014d38a599e3fd37672108].[dbo].[property].[propertyID] as [P].[propertyID]"><Identifier><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="18" 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="Expr1007"></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="Expr1007"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></UsedUDXColumns><RelOp NodeId="19" 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="20" PhysicalOp="Assert" LogicalOp="Assert" EstimateRows="2.55556" EstimateIO="0" EstimateCPU="3.82667e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0094788" Parallel="0" EstimateRebinds="7.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Assert StartupExpression="0"><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="2.55556" EstimateIO="0" EstimateCPU="3.82667e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="0.0094788" Parallel="0" EstimateRebinds="7.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference><ColumnReference Column="Recr1013"></ColumnReference><ColumnReference Column="Recr1014"></ColumnReference></OuterReferences><RelOp NodeId="22" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="4.55556e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.55556e-08" Parallel="0" EstimateRebinds="7.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference><ColumnReference Column="Recr1013"></ColumnReference><ColumnReference Column="Recr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="[Expr1044]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1044"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="4.55556e-08" AvgRowSize="8045" EstimatedTotalSubtreeCost="4.55556e-08" Parallel="0" EstimateRebinds="7.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1044"></ColumnReference><ColumnReference Column="Recr1010"></ColumnReference><ColumnReference Column="Recr1011"></ColumnReference><ColumnReference Column="Recr1012"></ColumnReference><ColumnReference Column="Recr1013"></ColumnReference><ColumnReference Column="Recr1014"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" 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="9" Stack="1"></Spool></RelOp></ComputeScalar></RelOp><RelOp NodeId="24" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.55556" EstimateIO="0" EstimateCPU="1.55556e-07" AvgRowSize="8049" EstimatedTotalSubtreeCost="0.00947837" Parallel="0" EstimateRebinds="6.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference><ColumnReference Column="Expr1024"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="[Recr1011]+(1)"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Recr1011"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="concat_ws(N&apos;.&apos;,[Recr1012],[Expr1036])"><Intrinsic FunctionName="concat_ws"><ScalarOperator><Const ConstValue="N&apos;.&apos;"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Recr1012"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1036"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1035] THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1035"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1024"></ColumnReference><ScalarOperator ScalarString="[Expr1022]"><Identifier><ColumnReference Column="Expr1022"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="25" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.55556" EstimateIO="0" EstimateCPU="6.50222e-06" AvgRowSize="4054" EstimatedTotalSubtreeCost="0.00947718" Parallel="0" EstimateRebinds="6.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Column="Expr1022"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="14" ActualExecutions="14"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></OuterReferences><RelOp NodeId="26" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1.55556" EstimateIO="0" EstimateCPU="6.50222e-06" AvgRowSize="1136" EstimatedTotalSubtreeCost="0.00940332" Parallel="0" EstimateRebinds="6.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference><ColumnReference Column="Expr1035"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="14" ActualExecutions="14"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><DefinedValues><DefinedValue><ColumnReference Column="Expr1035"></ColumnReference></DefinedValue></DefinedValues><OuterReferences><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></OuterReferences><ProbeColumn><ColumnReference Column="Expr1035"></ColumnReference></ProbeColumn><RelOp NodeId="27" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.55556" EstimateIO="0" EstimateCPU="1.55556e-07" AvgRowSize="1135" EstimatedTotalSubtreeCost="0.00434298" Parallel="0" EstimateRebinds="6.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference><ColumnReference Column="Expr1036"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1036"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(12),[fiddle_d4bf163509014d38a599e3fd37672108].[dbo].[property].[propertyID] as [P].[propertyID],0)"><Convert DataType="nvarchar" Length="24" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="28" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1.55556" EstimatedRowsRead="1.55556" EstimateIO="0.003125" EstimateCPU="0.000158711" AvgRowSize="1121" EstimatedTotalSubtreeCost="0.00434179" TableCardinality="14" Parallel="0" EstimateRebinds="6.66667" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="14" ActualLogicalReads="28" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="11" ActualEndOfScans="14" ActualExecutions="14"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="1" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Index="[IX_dbo_property__parentID]" Alias="[P]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="parentID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Recr1010]"><Identifier><ColumnReference Column="Recr1010"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp><RelOp NodeId="29" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateRowsWithoutRowGoal="1.55556" EstimatedRowsRead="1.55556" EstimateIO="0.003125" EstimateCPU="0.000158711" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00501049" TableCardinality="14" Parallel="0" EstimateRebinds="10.9259" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="11" ActualLogicalReads="22" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="7" ActualEndOfScans="4" ActualExecutions="11"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues></DefinedValues><Object Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Index="[IX_dbo_property__parentID]" Alias="[C]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[C]" Column="parentID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_d4bf163509014d38a599e3fd37672108].[dbo].[property].[propertyID] as [P].[propertyID]"><Identifier><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp><RelOp NodeId="30" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-06" AvgRowSize="4035" EstimatedTotalSubtreeCost="2.40089e-05" Parallel="0" EstimateRebinds="10.9259" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1022"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="11"></RunTimeCountersPerThread></RunTimeInformation><Extension UDXName="FOR JSON"><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"></ColumnReference></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="propertyID"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="title"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="typeid"></ColumnReference><ColumnReference Database="[fiddle_d4bf163509014d38a599e3fd37672108]" Schema="[dbo]" Table="[property]" Alias="[P]" Column="value"></ColumnReference></UsedUDXColumns><RelOp NodeId="31" 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="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="11" ActualExecutions="11"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></Extension></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></NestedLoops></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1045]&gt;(100) THEN (0) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1045"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(100)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Predicate></Assert></RelOp></Concat></RelOp></Spool></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>