add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
proj_id zeile
1 Aa
Bb
Cc
2 Dd
3 Ee
Ff
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.3.1" Build="12.0.5000.0"><BatchSequence><Batch><Statements><StmtSimple StatementText="select proj_id,&#xa; stuff( ( select distinct char(13) + char(10) + pn&#xa; from pn&#xa; where proj_id = t.proj_id&#xa; order by 1&#xa; for xml path(&apos;&apos;), type).value(&apos;.&apos;, &apos;varchar( max )&apos; ), 1, len(char(13) + char(10)), &apos;&apos; ) as zeile&#xa;from pn t&#xa;group by proj_id" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="3.31129" StatementEstRows="3" StatementOptmLevel="FULL" QueryHash="0xFEAE2EC81C34B687" QueryPlanHash="0x241DE06EA52615E9" CardinalityEstimationModelVersion="120"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"/><QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="48" CompileTime="15" CompileCPU="15" CompileMemory="712"><Warnings><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(varchar(max),[Expr1029],0)"/><PlanAffectingConvert ConvertIssue="Cardinality Estimate" Expression="CONVERT_IMPLICIT(varchar(max),[Expr1028],0)"/><MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="1024" GrantedMemory="1024" MaxUsedMemory="32"/></Warnings><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" RequiredMemory="640" DesiredMemory="704" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="32" MaxQueryMemory="150656"/><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="209662" EstimatedPagesCached="13103" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="360008"/><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"/></TraceFlags><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3" EstimateIO="0" EstimateCPU="3e-007" AvgRowSize="4039" EstimatedTotalSubtreeCost="3.31129" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/><ColumnReference Column="Expr1032"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1032"/><ScalarOperator ScalarString="stuff([Expr1031],(1),(2),&apos;&apos;)"><Intrinsic FunctionName="stuff"><ScalarOperator><Identifier><ColumnReference Column="Expr1031"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"/></ScalarOperator><ScalarOperator><Const ConstValue="(2)"/></ScalarOperator><ScalarOperator><Const ConstValue="&apos;&apos;"/></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3" EstimateIO="0" EstimateCPU="1.254e-005" AvgRowSize="4039" EstimatedTotalSubtreeCost="3.31129" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/><ColumnReference Column="Expr1031"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></OuterReferences><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="3" EstimateIO="0.0112613" EstimateCPU="0.000124206" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0146741" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></OutputList><MemoryFractions Input="1" Output="0.5"/><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="6" EstimateIO="0.003125" EstimateCPU="0.0001636" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0032886" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="6" ActualEndOfScans="1" ActualExecutions="1"/></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></DefinedValue></DefinedValues><Object Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Index="[PK__pn__3213E83FFA66C1AD]" Alias="[t]" IndexKind="Clustered" Storage="RowStore"/></IndexScan></RelOp></Sort></RelOp><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="4035" EstimatedTotalSubtreeCost="3.2966" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1031"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"/></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1005"/></OuterReferences><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0375657" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"/><ScalarOperator ScalarString="[Expr1004]"><Identifier><ColumnReference Column="Expr1004"/></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-006" AvgRowSize="4035" EstimatedTotalSubtreeCost="0.0375654" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"/></RunTimeInformation><Extension UDXName="FOR XML"><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"/></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Column="Expr1003"/></UsedUDXColumns><RelOp NodeId="7" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="2" EstimateIO="0.0112613" EstimateCPU="0.000103133" AvgRowSize="13" EstimatedTotalSubtreeCost="0.0375624" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"/></OutputList><MemoryFractions Input="0.5" Output="0.5"/><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><Sort Distinct="1"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"/></OrderByColumn></OrderBy><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="2" EstimateIO="0" EstimateCPU="6e-007" AvgRowSize="17" EstimatedTotalSubtreeCost="0.0034606" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"/><ScalarOperator ScalarString="&apos;&#xd;&#xa;&apos;+[fiddle_85f583fa809444e8aebee8ed9d036464].[dbo].[pn].[pn]"><Arithmetic Operation="ADD"><ScalarOperator><Const ConstValue="&apos;&#xd;&#xa;&apos;"/></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Column="pn"/></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="2" EstimateIO="0.0032035" EstimateCPU="8.51e-005" AvgRowSize="17" EstimatedTotalSubtreeCost="0.0034588" TableCardinality="6" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Column="pn"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" ActualElapsedms="0" ActualCPUms="0" ActualScans="3" ActualLogicalReads="6" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="18" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Column="pn"/></DefinedValue></DefinedValues><Object Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Index="[PK__pn__3213E83FFA66C1AD]" IndexKind="Clustered" Storage="RowStore"/><Predicate><ScalarOperator ScalarString="[fiddle_85f583fa809444e8aebee8ed9d036464].[dbo].[pn].[proj_id]=[fiddle_85f583fa809444e8aebee8ed9d036464].[dbo].[pn].[proj_id] as [t].[proj_id]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Column="proj_id"/></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_85f583fa809444e8aebee8ed9d036464]" Schema="[dbo]" Table="[pn]" Alias="[t]" Column="proj_id"/></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></ComputeScalar></RelOp></Sort></RelOp></Extension></RelOp></ComputeScalar></RelOp><RelOp NodeId="16" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="0.0048005" AvgRowSize="4035" EstimatedTotalSubtreeCost="3.25902" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1031"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="3"/></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1031"/><ScalarOperator ScalarString="MIN(CASE WHEN [Expr1005] IS NULL THEN NULL ELSE CASE WHEN datalength([Expr1028])&gt;=(128) THEN CONVERT_IMPLICIT(varchar(max),[Expr1029],0) ELSE CONVERT_IMPLICIT(varchar(max),[Expr1028],0) END END)"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="IS"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"/></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="NULL"/></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"/></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Intrinsic FunctionName="datalength"><ScalarOperator><Identifier><ColumnReference Column="Expr1028"/></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(128)"/></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1029"/></Identifier></ScalarOperator></Convert></ScalarOperator></Then><Else><ScalarOperator><Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1028"/></Identifier></ScalarOperator></Convert></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="UDX" LogicalOp="UDX" EstimateRows="8000" EstimateIO="0" EstimateCPU="0.008" AvgRowSize="8045" EstimatedTotalSubtreeCost="3.24462" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1028"/><ColumnReference Column="Expr1029"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><Extension UDXName="XQUERY DATA"><DefinedValues><DefinedValue><ColumnReference Column="Expr1026"/></DefinedValue><DefinedValue><ColumnReference Column="Expr1027"/></DefinedValue><DefinedValue><ColumnReference Column="Expr1028"/></DefinedValue><DefinedValue><ColumnReference Column="Expr1029"/></DefinedValue><DefinedValue><ColumnReference Column="Expr1030"/></DefinedValue></DefinedValues><UsedUDXColumns><ColumnReference Table="[XML Reader]" Column="id"/><ColumnReference Table="[XML Reader]" Column="nid"/><ColumnReference Table="[XML Reader]" Column="tid"/><ColumnReference Table="[XML Reader]" Column="value"/><ColumnReference Table="[XML Reader]" Column="lvalue"/><ColumnReference Table="[XML Reader]" Column="lvaluebin"/><ColumnReference Column="Expr1022"/><ColumnReference Table="[XML Reader]" Column="id"/></UsedUDXColumns><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.001" AvgRowSize="12983" EstimatedTotalSubtreeCost="3.22062" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1022"/><ColumnReference Table="[XML Reader]" Column="id"/><ColumnReference Table="[XML Reader]" Column="nid"/><ColumnReference Table="[XML Reader]" Column="tid"/><ColumnReference Table="[XML Reader]" Column="value"/><ColumnReference Table="[XML Reader]" Column="lvalue"/><ColumnReference Table="[XML Reader]" Column="lvaluebin"/></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1022"/><ScalarOperator ScalarString="0x58"><Const ConstValue="0x58"/></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="10000" EstimateIO="0" EstimateCPU="0.01254" AvgRowSize="12531" EstimatedTotalSubtreeCost="3.21762" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"/><ColumnReference Table="[XML Reader]" Column="nid"/><ColumnReference Table="[XML Reader]" Column="tid"/><ColumnReference Table="[XML Reader]" Column="value"/><ColumnReference Table="[XML Reader]" Column="lvalue"/><ColumnReference Table="[XML Reader]" Column="lvaluebin"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1006"/></OuterReferences><RelOp NodeId="20" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="461" EstimatedTotalSubtreeCost="3.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="2" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="0x"><Const ConstValue="0x"/></ScalarOperator></Row></Values></ConstantScan></RelOp><RelOp NodeId="22" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="3000" EstimateIO="0" EstimateCPU="1.06" AvgRowSize="12531" EstimatedTotalSubtreeCost="3.18" Parallel="0" EstimateRebinds="2" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[XML Reader]" Column="id"/><ColumnReference Table="[XML Reader]" Column="nid"/><ColumnReference Table="[XML Reader]" Column="tid"/><ColumnReference Table="[XML Reader]" Column="value"/><ColumnReference Table="[XML Reader]" Column="lvalue"/><ColumnReference Table="[XML Reader]" Column="lvaluebin"/></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="3" ActualRewinds="0" ActualEndOfScans="3" ActualExecutions="3"/></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[XML Reader]" Column="id"/></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="nid"/></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="tid"/></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="value"/></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="lvalue"/></DefinedValue><DefinedValue><ColumnReference Table="[XML Reader]" Column="lvaluebin"/></DefinedValue></DefinedValues><Object Table="[XML Reader]"/><ParameterList><ScalarOperator ScalarString="[Expr1005]"><Identifier><ColumnReference Column="Expr1005"/></Identifier></ScalarOperator><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"/></ScalarOperator><ScalarOperator ScalarString="[Expr1006]"><Identifier><ColumnReference Column="Expr1006"/></Identifier></ScalarOperator><ScalarOperator ScalarString="NULL"><Const ConstValue="NULL"/></ScalarOperator></ParameterList></TableValuedFunction></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Extension></RelOp></StreamAggregate></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>