ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.0" Build="9.00.5000.00">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementText="(@P1 varbinary(4),@P2 varbinary(16),@P3 datetime)INSERT INTO #tt21 (_Q_001_F_000TRef, _Q_001_F_000RRef, _Q_001_F_001TRef, _Q_001_F_001RRef, _Q_001_F_002, _Q_001_F_003RRef, _Q_001_F_004) SELECT TOP 1000&#xA;T1._NodeTRef,&#xA;T1._NodeRRef,&#xA;T1._RecorderTRef,&#xA;T1._RecorderRRef,&#xA;T2._Period,&#xA;T2._Fld1476RRef,&#xA;T2._LineNo&#xA;FROM _InfoRgChngR2664 T1 WITH(NOLOCK)&#xA;LEFT OUTER JOIN _InfoRg1475 T2 WITH(NOLOCK)&#xA;ON (T1._RecorderTRef = T2._RecorderTRef AND T1._RecorderRRef = T2._RecorderRRef)&#xA;WHERE (T1._NodeTRef = @P1 AND T1._NodeRRef = @P2) AND (T2._Period &lt;= @P3)" StatementId="1" StatementCompId="1" StatementType="INSERT" StatementSubTreeCost="0.638851" StatementEstRows="1000" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound">
          <QueryPlan CachedPlanSize="41" CompileTime="8" CompileCPU="8" CompileMemory="512">
            <RelOp NodeId="0" PhysicalOp="Table Insert" LogicalOp="Insert" EstimateRows="1000" EstimateIO="0.0106664" EstimateCPU="0.001" AvgRowSize="9" EstimatedTotalSubtreeCost="0.638851" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
              <OutputList />
              <Update>
                <Object Database="[tempdb]" Schema="[dbo]" Table="[#tt21]" />
                <SetPredicate>
                  <ScalarOperator ScalarString="[tempdb].[dbo].[#tt21].[_Q_001_F_000TRef] = [ComResurs].[dbo].[_InfoRgChngR2664].[_NodeTRef] as [T1].[_NodeTRef],[tempdb].[dbo].[#tt21].[_Q_001_F_000RRef] = [ComResurs].[dbo].[_InfoRgChngR2664].[_NodeRRef] as [T1].[_NodeRRef],[tempdb].[dbo].[#tt21].[_Q_001_F_001TRef] = [ComResurs].[dbo].[_InfoRgChngR2664].[_RecorderTRef] as [T1].[_RecorderTRef],[tempdb].[dbo].[#tt21].[_Q_001_F_001RRef] = [ComResurs].[dbo].[_InfoRgChngR2664].[_RecorderRRef] as [T1].[_RecorderRRef],[tempdb].[dbo].[#tt21].[_Q_001_F_002] = [ComResurs].[dbo].[_InfoRg1475].[_Period] as [T2].[_Period],[tempdb].[dbo].[#tt21].[_Q_001_F_003RRef] = [ComResurs].[dbo].[_InfoRg1475].[_Fld1476RRef] as [T2].[_Fld1476RRef],[tempdb].[dbo].[#tt21].[_Q_001_F_004] = [ComResurs].[dbo].[_InfoRg1475].[_LineNo] as [T2].[_LineNo]">
                    <ScalarExpressionList>
                      <ScalarOperator>
                        <MultipleAssign>
                          <Assign>
                            <ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#tt21]" Column="_Q_001_F_000TRef" />
                            <ScalarOperator>
                              <Identifier>
                                <ColumnReference Database="[ComResurs]" Schema="[dbo]" Table="[_InfoRgChngR2664]" Alias="[T1]" Column="_NodeTRef" />
                              </Identifier>
                            </ScalarOperator>