SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE 
    dbo.expression_tree 
(
  expression_id bigint,
  node_id bigint PRIMARY KEY,
  value varchar(12),
  side char(1),
  parent_node_id bigint
);
INSERT 
    dbo.expression_tree
SELECT 
    tmp.* 
FROM 
(
    VALUES
        (1, 1, '-', NULL, NULL), -- "-" at top
        (1, 2, '7', 'L', 1), 
        (1, 3, '*', 'R', 1), 
        (1, 4, '2', 'L', 3), 
        (1, 5, '3', 'R', 3)
) AS tmp (expression_id, node_id, value, side, parent_node_id);
5 rows affected

CREATE TABLE 
    #tree 
(
  node_id bigint PRIMARY KEY,
  value bigint,
  op varchar(2),
  side char(1),
  parent_node_id bigint,
  INDEX IX (parent_node_id) INCLUDE (side, value),
  CHECK (parent_node_id <> node_id)
);
CREATE TABLE 
    #child 
(
  parent_node_id bigint PRIMARY KEY,
  L bigint,
  R bigint
);
INSERT 
    #tree
SELECT
  et.node_id,
  CASE WHEN et.value NOT LIKE '%[^0-9]%' THEN et.value END,
  CASE WHEN et.value LIKE '%[^0-9]%' THEN et.value END,
  et.side,
  et.parent_node_id
FROM expression_tree et
WHERE et.expression_id = 1;
5 rows affected

SET STATISTICS XML ON;

DECLARE 
    @final bigint, 
    @parent bigint;

WHILE 1=1
BEGIN
    WITH 
        child AS 
    (
        SELECT
          child.parent_node_id,
          MIN(CASE WHEN child.side = 'L' THEN child.value END) AS L,
          MIN(CASE WHEN child.side = 'R' THEN child.value END) AS R
        FROM #tree child
        WHERE child.parent_node_id IS NOT NULL
        GROUP BY
          child.parent_node_id
        HAVING COUNT(CASE WHEN child.value IS NULL THEN 1 END) = 0
    )
    INSERT 
        #child
        (
            parent_node_id,
            L,
            R
        )
    SELECT
        c.*
    FROM child AS c;

    UPDATE 
        t
    SET @final = v.final,
        value = v.final,
        @parent = t.parent_node_id
    FROM #tree AS t
    JOIN #child AS c 
      ON c.parent_node_id = t.node_id
    CROSS APPLY 
    (
        SELECT 
            CASE t.op
                 WHEN '+' THEN L + R
                 WHEN '-' THEN ISNULL(L, 0) - R
                 WHEN '*' THEN L * R
                 WHEN '/' THEN L / R
                 WHEN '%' THEN L % R
            END
    ) v(final)
    WHERE t.value IS NULL;

    TRUNCATE TABLE
        #child;
        
    IF @@ROWCOUNT = 0 OR @parent IS NULL
        BREAK;
END;

SELECT 
    @final;


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH &#xa;        child AS &#xa;    (&#xa;        SELECT&#xa;          child.parent_node_id,&#xa;          MIN(CASE WHEN child.side = &apos;L&apos; THEN child.value END) AS L,&#xa;          MIN(CASE WHEN child.side = &apos;R&apos; THEN child.value END) AS R&#xa;        FROM #tree child&#xa;        WHERE child.parent_node_id IS NOT NULL&#xa;        GROUP BY&#xa;          child.parent_node_id&#xa;        HAVING COUNT(CASE WHEN child.value IS NULL THEN 1 END) = 0&#xa;    )&#xa;    INSERT &#xa;        #child&#xa;        (&#xa;            parent_node_id,&#xa;            L,&#xa;            R&#xa;        )&#xa;    SELECT&#xa;        c.*&#xa;    FROM child AS c" StatementId="1" StatementCompId="3" StatementType="INSERT" StatementSqlHandle="0x090058117D553641B7E139D6058C3AF003D90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" BatchSqlHandle="0x02000000926B6E1C69422446CE13E2366E884AE5DD98E2080000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0132922" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xA015E3593105B1D0" QueryPlanHash="0x91A8E011EC24C79A" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="40" CompileTime="22" CompileCPU="22" CompileMemory="520"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2494048"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-03-28T16:41:33.75" ModificationCount="0" SamplingPercent="100" Statistics="[IX]" Table="[#tree_______________________________________________________________________________________________________________000000005FA9]" 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="Clustered Index Insert" LogicalOp="Insert" EstimateRows="1" EstimateIO="0.01" EstimateCPU="1e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0132922" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="3" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Schema="[dbo]" Table="[#child]" Index="[PK__#child____CAD5EDBE70AE333E]" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[#child].[parent_node_id] = #tree.[parent_node_id] as [child].[parent_node_id],[#child].[L] = [Expr1004],[#child].[R] = [Expr1005]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="[#child]" Column="parent_node_id"></ColumnReference><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[#child]" Column="L"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Table="[#child]" Column="R"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="9.6e-07" AvgRowSize="31" EstimatedTotalSubtreeCost="0.00329116" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="0" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0032902" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1013],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1013"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="2" EstimateIO="0" EstimateCPU="3.4e-06" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0032902" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="COUNT([Expr1006])"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MIN([Expr1007])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="MIN([Expr1008])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference></GroupBy><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4" EstimateIO="0" EstimateCPU="4e-07" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0032868" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN #tree.[value] as [child].[value] IS NULL THEN (1) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN #tree.[side] as [child].[side]=&apos;L&apos; THEN #tree.[value] as [child].[value] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="side"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;L&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="value"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN #tree.[side] as [child].[side]=&apos;R&apos; THEN #tree.[value] as [child].[value] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="side"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;R&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[child]" Column="value"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="4" EstimatedRowsRead="4" EstimateIO="0.003125" EstimateCPU="0.0001614" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0032864" TableCardinality="5" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[child]" Column="value"></ColumnReference><ColumnReference Table="#tree" Alias="[child]" Column="side"></ColumnReference><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="4" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tree" Alias="[child]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tree" Alias="[child]" Column="side"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tree]" Index="[IX]" Alias="[child]" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><IsNotNull><ColumnReference Table="#tree" Alias="[child]" Column="parent_node_id"></ColumnReference></IsNotNull></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></ComputeScalar></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1003]=(0)"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


Warning: Null value is eliminated by an aggregate or other SET operation.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="UPDATE &#xa;        t&#xa;    SET @final = v.final,&#xa;        value = v.final,&#xa;        @parent = t.parent_node_id&#xa;    FROM #tree AS t&#xa;    JOIN #child AS c &#xa;      ON c.parent_node_id = t.node_id&#xa;    CROSS APPLY &#xa;    (&#xa;        SELECT &#xa;            CASE t.op&#xa;                 WHEN &apos;+&apos; THEN L + R&#xa;                 WHEN &apos;-&apos; THEN ISNULL(L, 0) - R&#xa;                 WHEN &apos;*&apos; THEN L * R&#xa;                 WHEN &apos;/&apos; THEN L / R&#xa;                 WHEN &apos;%&apos; THEN L % R&#xa;            END&#xa;    ) v(final)&#xa;    WHERE t.value IS NULL" StatementId="2" StatementCompId="4" StatementType="UPDATE" StatementSqlHandle="0x0900BF0913523E06A0414C142E7BB32473CA0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" BatchSqlHandle="0x02000000926B6E1C69422446CE13E2366E884AE5DD98E2080000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0265733" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE3B9750892E8AC63" QueryPlanHash="0x484307C6EED5F346" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="64" CompileTime="31" CompileCPU="31" CompileMemory="480"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="2491280"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-03-28T16:41:33.98" ModificationCount="0" SamplingPercent="100" Statistics="[PK__#tree_____5F19EF165CEA6463]" Table="[#tree_______________________________________________________________________________________________________________000000005FA9]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-03-28T16:41:33.76" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_A22A4A18]" Table="[#tree_______________________________________________________________________________________________________________000000005FA9]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-03-28T16:41:33.98" ModificationCount="0" SamplingPercent="100" Statistics="[PK__#child____CAD5EDBE70AE333E]" Table="[#child______________________________________________________________________________________________________________000000005FAA]" 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="1" PhysicalOp="Clustered Index Update" LogicalOp="Update" EstimateRows="1" EstimateIO="0.02" EstimateCPU="2e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0265733" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[tempdb]" Schema="[dbo]" Table="[#tree]" Index="[PK__#tree_____5F19EF165CEA6463]" Alias="[t]" Storage="RowStore"></Object><Object Database="[tempdb]" Schema="[dbo]" Table="[#tree]" Index="[IX]" Alias="[t]" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[@final] = [Expr1003],[@parent] = [Expr1004],#tree.[value] as [t].[value] = [Expr1002]"><ScalarExpressionList><ScalarOperator><Assign><ScalarOperator><Identifier><ColumnReference Column="@final"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Assign></ScalarOperator><ScalarOperator><Assign><ScalarOperator><Identifier><ColumnReference Column="@parent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Assign></ScalarOperator><ScalarOperator><MultipleAssign><Assign><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="43" EstimatedTotalSubtreeCost="0.00657126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="[Expr1007]"><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="43" EstimatedTotalSubtreeCost="0.00657126" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1006] THEN (0) ELSE (1) END"><IF><Condition><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="40" EstimatedTotalSubtreeCost="0.00657116" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN #tree.[value] as [t].[value] = [Expr1002] THEN (1) ELSE (0) END"><IF><Condition><ScalarOperator><Compare CompareOp="BINARY IS"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="47" EstimatedTotalSubtreeCost="0.00657106" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="[@final] = CASE WHEN #tree.[op] as [t].[op]=&apos;+&apos; THEN #child.[L] as [c].[L]+#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;-&apos; THEN isnull(#child.[L] as [c].[L],(0))-#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;*&apos; THEN #child.[L] as [c].[L]*#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;/&apos; THEN #child.[L] as [c].[L]/#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;%&apos; THEN #child.[L] as [c].[L]%#child.[R] as [c].[R] ELSE NULL END END END END END"><Assign><ScalarOperator><Identifier><ColumnReference Column="@final"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;+&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;-&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Intrinsic FunctionName="isnull"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;*&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;/&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MOD"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Assign></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="[@parent] = #tree.[parent_node_id] as [t].[parent_node_id]"><Assign><ScalarOperator><Identifier><ColumnReference Column="@parent"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="parent_node_id"></ColumnReference></Identifier></ScalarOperator></Assign></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="60" EstimatedTotalSubtreeCost="0.00657096" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="parent_node_id"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="CASE WHEN #tree.[op] as [t].[op]=&apos;+&apos; THEN #child.[L] as [c].[L]+#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;-&apos; THEN isnull(#child.[L] as [c].[L],(0))-#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;*&apos; THEN #child.[L] as [c].[L]*#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;/&apos; THEN #child.[L] as [c].[L]/#child.[R] as [c].[R] ELSE CASE WHEN #tree.[op] as [t].[op]=&apos;%&apos; THEN #child.[L] as [c].[L]%#child.[R] as [c].[R] ELSE NULL END END END END END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;+&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;-&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Intrinsic FunctionName="isnull"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;*&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MULT"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;/&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="DIV"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;%&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MOD"><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="52" EstimatedTotalSubtreeCost="0.00657086" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="parent_node_id"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="#child" Alias="[c]" Column="parent_node_id"></ColumnReference></OuterReferences><RelOp NodeId="8" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#child" Alias="[c]" Column="parent_node_id"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#child" Alias="[c]" Column="parent_node_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#child" Alias="[c]" Column="L"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#child" Alias="[c]" Column="R"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#child]" Index="[PK__#child____CAD5EDBE70AE333E]" Alias="[c]" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="9" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="36" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference><ColumnReference Table="#tree" Alias="[t]" Column="parent_node_id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tree" Alias="[t]" Column="op"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="#tree" Alias="[t]" Column="parent_node_id"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#tree]" Index="[PK__#tree_____5F19EF165CEA6463]" Alias="[t]" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Table="#tree" Alias="[t]" Column="node_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="#child.[parent_node_id] as [c].[parent_node_id]"><Identifier><ColumnReference Table="#child" Alias="[c]" Column="parent_node_id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="#tree.[value] as [t].[value] IS NULL"><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Table="#tree" Alias="[t]" Column="value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></ComputeScalar></RelOp></Update></RelOp><ParameterList><ColumnReference Column="@parent" ParameterDataType="bigint" ParameterRuntimeValue="(1)"></ColumnReference><ColumnReference Column="@final" ParameterDataType="bigint" ParameterRuntimeValue="(6)"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>




(No column name)


6