SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE src(xmlcolumn xml);
INSERT src VALUES ('<blah>hello1</blah><blah>hello2</blah><blah>hello3</blah>');
CREATE TABLE dst(id int primary key identity, value nvarchar(100))
1 rows affected

SET STATISTICS XML ON;
INSERT INTO dst(value)
SELECT blah.value('text()[1]','nvarchar(100)')
FROM src
CROSS APPLY xmlcolumn.nodes('blah') x(blah)

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="INSERT INTO dst(value)&#xa;SELECT blah.value(&apos;text()[1]&apos;,&apos;nvarchar(100)&apos;)&#xa;FROM src&#xa;CROSS APPLY xmlcolumn.nodes(&apos;blah&apos;) x(blah)" StatementId="1" StatementCompId="2" StatementType="INSERT" RetrievedFromCache="true" StatementSubTreeCost="181.097" StatementEstRows="180" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x910EF6A4E30BC08B" QueryPlanHash="0x75FB555F0C5A6443" 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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="48" CompileTime="0" CompileCPU="0" CompileMemory="792"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[lvalue],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[value],0)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="7110112"></OptimizerHardwareDependentProperties><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="180" EstimateIO="0.0203166" EstimateCPU="0.00018" AvgRowSize="9" EstimatedTotalSubtreeCost="181.097" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="7" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Index="[PK__dst__3213E83F6FD8FBD0]" IndexKind="Clustered" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[dst].[value] = [Expr1016],[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[dst].[id] = [Expr1009]"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Column="value"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1016"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Column="id"></ColumnReference><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="180" EstimateIO="0" EstimateCPU="1.8e-05" AvgRowSize="115" EstimatedTotalSubtreeCost="181.076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="[Expr1015]"><Identifier><ColumnReference Column="Expr1015"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="180" EstimateIO="0" EstimateCPU="0.0007524" AvgRowSize="115" EstimatedTotalSubtreeCost="181.076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1015"></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_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="180" EstimateIO="0" EstimateCPU="1.8e-05" AvgRowSize="4491" EstimatedTotalSubtreeCost="1.00815" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ComputeScalar ComputeSequence="1"><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="getidentity((597577167),(15),NULL)"><Intrinsic FunctionName="getidentity"><ScalarOperator><Const ConstValue="(597577167)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="180" EstimateIO="0" EstimateCPU="0.0007524" AvgRowSize="4487" EstimatedTotalSubtreeCost="1.00813" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></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_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="6" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="180" EstimateIO="0" EstimateCPU="9.6e-05" AvgRowSize="461" EstimatedTotalSubtreeCost="1.0041" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="7" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="200" EstimateIO="0" EstimateCPU="1.004" AvgRowSize="461" EstimatedTotalSubtreeCost="1.004" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp><RelOp NodeId="8" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="111" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1015"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="MIN(CASE WHEN [fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])&gt;=(128) THEN CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[value],0) END END)"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Convert DataType="nvarchar" Length="200" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Then><Else><ScalarOperator><Convert DataType="nvarchar" Length="200" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="8949" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1014"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.224e-05" AvgRowSize="8497" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="12" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="18" EstimateIO="0" EstimateCPU="1.00036" AvgRowSize="8497" EstimatedTotalSubtreeCost="180.065" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getancestor"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></Top></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Update></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

SELECT * FROM dst;

id
value

1
hello1

2
hello2

3
hello3

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="SELECT * FROM dst" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0032853" StatementEstRows="3" SecurityPolicyApplied="false" StatementOptmLevel="TRIVIAL" QueryHash="0xFBC7A02AEACBF831" QueryPlanHash="0xAE96A17EAE96DD23" 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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="16" CompileTime="0" CompileCPU="0" CompileMemory="80"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="7110112"></OptimizerHardwareDependentProperties><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 Scan" LogicalOp="Clustered Index Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="115" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Column="id"></ColumnReference><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" 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="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Column="value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[dst]" Index="[PK__dst__3213E83F6FD8FBD0]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>

SELECT T.X.value('text()[1]', 'nvarchar(100)') as RowLabel,
       T.X.value('let $i := . return count(../*[. << $i]) + 1', 'int') as RowNumber
FROM src
CROSS APPLY xmlcolumn.nodes('blah') as T(X);

RowLabel
RowNumber

hello1
1

hello2
2

hello3
3

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="SELECT T.X.value(&apos;text()[1]&apos;, &apos;nvarchar(100)&apos;) as RowLabel,&#xa;       T.X.value(&apos;let $i := . return count(../*[. &lt;&lt; $i]) + 1&apos;, &apos;int&apos;) as RowNumber&#xa;FROM src&#xa;CROSS APPLY xmlcolumn.nodes(&apos;blah&apos;) as T(X)" StatementId="1" StatementCompId="1" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="762.267" StatementEstRows="180" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x95245B96FDFBF1FB" QueryPlanHash="0x93E03D44FFBCCCD9" 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" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="88" CompileTime="15" CompileCPU="15" CompileMemory="1440"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[lvalue],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[value],0)"></PlanAffectingConvert><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0)"></PlanAffectingConvert></Warnings><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="7110112"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="180" EstimateIO="0" EstimateCPU="1.8e-05" AvgRowSize="115" EstimatedTotalSubtreeCost="762.267" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1013"></ColumnReference><ColumnReference Column="Expr1027"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1013"></ColumnReference><ScalarOperator ScalarString="[Expr1012]"><Identifier><ColumnReference Column="Expr1012"></ColumnReference></Identifier></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"></ColumnReference><ScalarOperator ScalarString="[Expr1026]"><Identifier><ColumnReference Column="Expr1026"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="180" EstimateIO="0" EstimateCPU="0.0007524" AvgRowSize="115" EstimatedTotalSubtreeCost="762.267" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1012"></ColumnReference><ColumnReference Column="Expr1026"></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_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="180" EstimateIO="0" EstimateCPU="0.0007524" AvgRowSize="4589" EstimatedTotalSubtreeCost="181.076" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Column="Expr1012"></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_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="180" EstimateIO="0" EstimateCPU="0.0007524" AvgRowSize="4487" EstimatedTotalSubtreeCost="1.00813" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></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_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></OuterReferences><RelOp NodeId="4" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="5" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="180" EstimateIO="0" EstimateCPU="9.6e-05" AvgRowSize="461" EstimatedTotalSubtreeCost="1.0041" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="6" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="200" EstimateIO="0" EstimateCPU="1.004" AvgRowSize="461" EstimatedTotalSubtreeCost="1.004" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn] IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp><RelOp NodeId="7" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="111" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1012"></ColumnReference><ScalarOperator ScalarString="MIN(CASE WHEN [fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])&gt;=(128) THEN CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(nvarchar(100),XML Reader with XPath filter.[value],0) END END)"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Convert DataType="nvarchar" Length="200" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Then><Else><ScalarOperator><Convert DataType="nvarchar" Length="200" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="8045" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="8949" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"></Const></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.224e-05" AvgRowSize="8497" EstimatedTotalSubtreeCost="180.067" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="11" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="18" EstimateIO="0" EstimateCPU="1.00036" AvgRowSize="8497" EstimatedTotalSubtreeCost="180.065" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="value"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader with XPath filter]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1))"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getancestor"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></Top></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp><RelOp NodeId="12" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="11" EstimatedTotalSubtreeCost="581.19" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"></ColumnReference><ScalarOperator ScalarString="MIN(CASE WHEN [fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn] IS NULL THEN NULL ELSE CASE WHEN datalength(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(nvarchar(64),xsd_cast_to_maybe_large(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0),NULL,NULL,(318767123),(15),(15),(0)),0),0))&gt;=(128) THEN CONVERT_IMPLICIT(int,CASE WHEN datalength(xsd_cast_to_maybe_large(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0),NULL,NULL,(318767123),(15),(15),(0)))&lt;(128) THEN NULL ELSE xsd_cast_to_maybe_large(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0),NULL,NULL,(318767123),(15),(15),(0)) END,0) ELSE CONVERT_IMPLICIT(int,CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(nvarchar(64),xsd_cast_to_maybe_large(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0),NULL,NULL,(318767123),(15),(15),(0)),0),0),0) END END)"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Convert DataType="nvarchar" Length="128" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="xsd_cast_to_maybe_large"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(318767123)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Intrinsic FunctionName="xsd_cast_to_maybe_large"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(318767123)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Intrinsic FunctionName="xsd_cast_to_maybe_large"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(318767123)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Else></IF></ScalarOperator></Convert></ScalarOperator></Then><Else><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Convert DataType="nvarchar" Length="128" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="xsd_cast_to_maybe_large"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(318767123)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator></Convert></ScalarOperator></Convert></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.78e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="581.19" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="14" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="1.1e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="581.19" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1023"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Nested Loops" LogicalOp="Left Semi Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="9" EstimatedTotalSubtreeCost="581.189" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="XML Reader.[id]&lt;XML Reader.[id]"><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="16" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-06" AvgRowSize="461" EstimatedTotalSubtreeCost="401.185" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OuterReferences><RelOp NodeId="17" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0108" AvgRowSize="461" EstimatedTotalSubtreeCost="217.944" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="18" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="10000" EstimateIO="0" EstimateCPU="1.2" AvgRowSize="465" EstimatedTotalSubtreeCost="216" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="21" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="getparent(XML Reader.[id])=getparent(XML Reader with XPath filter.[id]) AND XML Reader.[nid]=(1)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Intrinsic FunctionName="getparent"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Intrinsic FunctionName="getparent"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="nid"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp><RelOp NodeId="19" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="9.8e-07" AvgRowSize="9" EstimatedTotalSubtreeCost="183.24" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="9"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="20" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="900" EstimateIO="0" EstimateCPU="1.018" AvgRowSize="461" EstimatedTotalSubtreeCost="183.24" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="9" ActualRewinds="0" ActualEndOfScans="0" ActualExecutions="9"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator ScalarString="getparent(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getparent"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator ScalarString="getparent(XML Reader with XPath filter.[id])"><Intrinsic FunctionName="getparent"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp><Predicate><ScalarOperator ScalarString="XML Reader.[id]&lt;XML Reader.[id] AND getdescendantlimit(XML Reader.[id])&gt;XML Reader.[id]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="getdescendantlimit"><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp><RelOp NodeId="21" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="1" EstimateIO="0" EstimateCPU="1.00002" AvgRowSize="461" EstimatedTotalSubtreeCost="180.004" Parallel="0" EstimateRebinds="179" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="9" ActualRewinds="0" ActualEndOfScans="6" ActualExecutions="9"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"></ColumnReference></DefinedValue></DefinedValues><Object Table="[XML Reader]"></Object><ParameterList><ScalarOperator ScalarString="[fiddle_faef7103e52e49618192ad3522101d87].[dbo].[src].[xmlcolumn]"><Identifier><ColumnReference Database="[fiddle_faef7103e52e49618192ad3522101d87]" Schema="[dbo]" Table="[src]" Column="xmlcolumn"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(15)"><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="XML Reader with XPath filter.[id]"><Identifier><ColumnReference Table="[XML Reader with XPath filter]" Column="id"></ColumnReference></Identifier></ScalarOperator></ParameterList></TableValuedFunction></RelOp></NestedLoops></RelOp></StreamAggregate></RelOp><Predicate><ScalarOperator ScalarString="CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(nvarchar(64),xsd_cast_to_maybe_large(CONVERT_IMPLICIT(sql_variant,CONVERT_IMPLICIT(numeric(38,10),[Expr1023],0)+(1.0000000000),0),NULL,NULL,(318767123),(15),(15),(0)),0),0) IS NOT NULL"><Compare CompareOp="IS NOT"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Convert DataType="nvarchar" Length="128" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="xsd_cast_to_maybe_large"><ScalarOperator><Convert DataType="sql_variant" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="numeric" Precision="38" Scale="10" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1023"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="(1.0000000000)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(318767123)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(15)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></Filter></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>