<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.0" Build="9.00.3152.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="118.45" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="726.064" StatementText="SELECT TP.LocID&#xD;&#xA;      ,TP.Date&#xD;&#xA;      ,Rainfall.value('(/RT/RN[@H=15]/@H)[1]','tinyint') AS Hour&#xD;&#xA;      ,Rainfall.value('(/RT/RN[@H=15]/@V)[1]','numeric(10,8)') AS Rainfall&#xD;&#xA;  FROM Rainfall_XML TP&#xD;&#xA; WHERE TP.Date = '20080106'&#xD;&#xA; ORDER BY LocID&#xD;&#xA;" StatementType="SELECT">
          <StatementSetOptions ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="false" />
          <QueryPlan CachedPlanSize="123" CompileTime="51" CompileCPU="39" CompileMemory="1400">
            <RelOp AvgRowSize="29" EstimateCPU="1.1845E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="726.064">
              <OutputList>
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                <ColumnReference Column="Expr1016" />
                <ColumnReference Column="Expr1031" />
              </OutputList>
              <ComputeScalar>
                <DefinedValues>
                  <DefinedValue>
                    <ColumnReference Column="Expr1016" />
                    <ScalarOperator ScalarString="[Expr1016]">
                      <Identifier>
                        <ColumnReference Column="Expr1016" />
                      </Identifier>
                    </ScalarOperator>
                  </DefinedValue>
                  <DefinedValue>
                    <ColumnReference Column="Expr1031" />
                    <ScalarOperator ScalarString="[Expr1031]">
                      <Identifier>
                        <ColumnReference Column="Expr1031" />
                      </Identifier>
                    </ScalarOperator>
                  </DefinedValue>
                </DefinedValues>
                <RelOp AvgRowSize="29" EstimateCPU="0.0293626" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="726.064">
                  <OutputList>
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                    <ColumnReference Column="Expr1016" />
                    <ColumnReference Column="Expr1031" />
                  </OutputList>
                  <Parallelism>
                    <OrderBy>
                      <OrderByColumn Ascending="true">
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                      </OrderByColumn>
                    </OrderBy>
                    <RelOp AvgRowSize="29" EstimateCPU="0.000247559" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Inner Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="726.034">
                      <OutputList>
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                        <ColumnReference Column="Expr1016" />
                        <ColumnReference Column="Expr1031" />
                      </OutputList>
                      <NestedLoops Optimized="false">
                        <OuterReferences>
                          <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                        </OuterReferences>
                        <RelOp AvgRowSize="4036" EstimateCPU="0.000247559" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="363.412">
                          <OutputList>
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                            <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                            <ColumnReference Column="Expr1016" />
                          </OutputList>
                          <NestedLoops Optimized="false">
                            <OuterReferences>
                              <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                            </OuterReferences>
                            <RelOp AvgRowSize="4035" EstimateCPU="0.000247559" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.790533">
                              <OutputList>
                                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                                <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                              </OutputList>
                              <NestedLoops Optimized="false" WithOrderedPrefetch="true">
                                <OuterReferences>
                                  <ColumnReference Column="Bmk1000" />
                                  <ColumnReference Column="Expr1044" />
                                </OuterReferences>
                                <RelOp AvgRowSize="27" EstimateCPU="0.0603585" EstimateIO="0.319421" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="118.45" LogicalOp="Index Scan" NodeId="6" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.37978">
                                  <OutputList>
                                    <ColumnReference Column="Bmk1000" />
                                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                                  </OutputList>
                                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Column="Bmk1000" />
                                      </DefinedValue>
                                      <DefinedValue>
                                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="LocID" />
                                      </DefinedValue>
                                      <DefinedValue>
                                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                                      </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Index="[PK_Rainfall_XML]" Alias="[TP]" />
                                    <Predicate>
                                      <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Date] as [TP].[Date]='2008-01-06 00:00:00.000'">
                                        <Compare CompareOp="EQ">
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Date" />
                                            </Identifier>
                                          </ScalarOperator>
                                          <ScalarOperator>
                                            <Const ConstValue="'2008-01-06 00:00:00.000'" />
                                          </ScalarOperator>
                                        </Compare>
                                      </ScalarOperator>
                                    </Predicate>
                                  </IndexScan>
                                </RelOp>
                                <RelOp AvgRowSize="4023" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="117.45" EstimateRewinds="0" EstimateRows="1" LogicalOp="RID Lookup" NodeId="8" Parallel="true" PhysicalOp="RID Lookup" EstimatedTotalSubtreeCost="0.384202">
                                  <OutputList>
                                    <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                  </OutputList>
                                  <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                      </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" TableReferenceId="-1" />
                                    <SeekPredicates>
                                      <SeekPredicate>
                                        <Prefix ScanType="EQ">
                                          <RangeColumns>
                                            <ColumnReference Column="Bmk1000" />
                                          </RangeColumns>
                                          <RangeExpressions>
                                            <ScalarOperator ScalarString="[Bmk1000]">
                                              <Identifier>
                                                <ColumnReference Column="Bmk1000" />
                                              </Identifier>
                                            </ScalarOperator>
                                          </RangeExpressions>
                                        </Prefix>
                                      </SeekPredicate>
                                    </SeekPredicates>
                                  </IndexScan>
                                </RelOp>
                              </NestedLoops>
                            </RelOp>
                            <RelOp AvgRowSize="9" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="Aggregate" NodeId="12" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="362.622">
                              <OutputList>
                                <ColumnReference Column="Expr1016" />
                              </OutputList>
                              <StreamAggregate>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1016" />
                                    <ScalarOperator ScalarString="MIN(CASE WHEN [ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])&gt;=(128) THEN CONVERT_IMPLICIT(tinyint,XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(tinyint,XML Reader with XPath filter.[value],0) END END)">
                                      <Aggregate AggType="MIN" Distinct="false">
                                        <ScalarOperator>
                                          <IF>
                                            <Condition>
                                              <ScalarOperator>
                                                <Compare CompareOp="IS">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                    </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 Table="[XML Reader with XPath filter]" Column="value" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </Intrinsic>
                                                        </ScalarOperator>
                                                        <ScalarOperator>
                                                          <Const ConstValue="(128)" />
                                                        </ScalarOperator>
                                                      </Compare>
                                                    </ScalarOperator>
                                                  </Condition>
                                                  <Then>
                                                    <ScalarOperator>
                                                      <Convert DataType="tinyint" Style="0" Implicit="true">
                                                        <ScalarOperator>
                                                          <Identifier>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </Convert>
                                                    </ScalarOperator>
                                                  </Then>
                                                  <Else>
                                                    <ScalarOperator>
                                                      <Convert DataType="tinyint" Style="0" Implicit="true">
                                                        <ScalarOperator>
                                                          <Identifier>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </Convert>
                                                    </ScalarOperator>
                                                  </Else>
                                                </IF>
                                              </ScalarOperator>
                                            </Else>
                                          </IF>
                                        </ScalarOperator>
                                      </Aggregate>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp AvgRowSize="5969" EstimateCPU="6.1869E-07" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="13" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="362.622">
                                  <OutputList>
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                    <ColumnReference Column="Expr1015" />
                                  </OutputList>
                                  <ComputeScalar>
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Column="Expr1015" />
                                        <ScalarOperator ScalarString="0x58">
                                          <Const ConstValue="0x58" />
                                        </ScalarOperator>
                                      </DefinedValue>
                                    </DefinedValues>
                                    <RelOp AvgRowSize="5517" EstimateCPU="0.000130893" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="TopN Sort" NodeId="14" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="362.621">
                                      <OutputList>
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                      </OutputList>
                                      <MemoryFractions Input="0" Output="0.5" />
                                      <TopSort Distinct="false" Rows="1">
                                        <OrderBy>
                                          <OrderByColumn Ascending="true">
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                          </OrderByColumn>
                                        </OrderBy>
                                        <RelOp AvgRowSize="5517" EstimateCPU="0.00603402" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="6.1869" LogicalOp="Inner Join" NodeId="15" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="361.273">
                                          <OutputList>
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                          </OutputList>
                                          <Merge ManyToMany="false">
                                            <InnerSideJoinColumns>
                                              <ColumnReference Column="Expr1033" />
                                            </InnerSideJoinColumns>
                                            <OuterSideJoinColumns>
                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                            </OuterSideJoinColumns>
                                            <Residual>
                                              <ScalarOperator ScalarString="XML Reader with XPath filter.[id]=[Expr1033] AND XML Reader with XPath filter.[id]&lt;=XML Reader with XPath filter.[id] AND [Expr1034]&gt;XML Reader with XPath filter.[id]">
                                                <Logical Operation="AND">
                                                  <ScalarOperator>
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1033" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="LE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="GT">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1034" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Logical>
                                              </ScalarOperator>
                                            </Residual>
                                            <RelOp AvgRowSize="913" EstimateCPU="0.00610398" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="3.43717" LogicalOp="Left Semi Join" NodeId="16" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="240.003">
                                              <OutputList>
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                <ColumnReference Column="Expr1034" />
                                              </OutputList>
                                              <Merge ManyToMany="false">
                                                <InnerSideJoinColumns>
                                                  <ColumnReference Column="Expr1035" />
                                                </InnerSideJoinColumns>
                                                <OuterSideJoinColumns>
                                                  <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                </OuterSideJoinColumns>
                                                <Residual>
                                                  <ScalarOperator ScalarString="XML Reader with XPath filter.[id]=[Expr1035] AND XML Reader with XPath filter.[id]&lt;=XML Reader with XPath filter.[id] AND [Expr1034]&gt;XML Reader with XPath filter.[id]">
                                                    <Logical Operation="AND">
                                                      <ScalarOperator>
                                                        <Compare CompareOp="EQ">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Column="Expr1035" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Compare CompareOp="LE">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Compare CompareOp="GT">
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Column="Expr1034" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Identifier>
                                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                        </Compare>
                                                      </ScalarOperator>
                                                    </Logical>
                                                  </ScalarOperator>
                                                </Residual>
                                                <RelOp AvgRowSize="913" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="17" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    <ColumnReference Column="Expr1034" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1034" />
                                                        <ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
                                                          <Intrinsic FunctionName="getdescendantlimit">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </Intrinsic>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="461" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="18" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                      <OutputList>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                      </OutputList>
                                                      <TableValuedFunction>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <Object Table="[XML Reader with XPath filter]" />
                                                        <ParameterList>
                                                          <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                            <Identifier>
                                                              <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="(0)">
                                                            <Const ConstValue="(0)" />
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="NULL">
                                                            <Const ConstValue="NULL" />
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="NULL">
                                                            <Const ConstValue="NULL" />
                                                          </ScalarOperator>
                                                        </ParameterList>
                                                      </TableValuedFunction>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                                <RelOp AvgRowSize="913" EstimateCPU="0.000414002" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="38.1907" LogicalOp="Sort" NodeId="26" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="120.353">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    <ColumnReference Column="Expr1035" />
                                                  </OutputList>
                                                  <MemoryFractions Input="0.0196078" Output="0.0196078" />
                                                  <Sort Distinct="false">
                                                    <OrderBy>
                                                      <OrderByColumn Ascending="true">
                                                        <ColumnReference Column="Expr1035" />
                                                      </OrderByColumn>
                                                    </OrderBy>
                                                    <RelOp AvgRowSize="913" EstimateCPU="0.000376" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="38.1907" LogicalOp="Filter" NodeId="27" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="118.97">
                                                      <OutputList>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        <ColumnReference Column="Expr1035" />
                                                      </OutputList>
                                                      <Filter StartupExpression="false">
                                                        <RelOp AvgRowSize="5973" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="28" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                                          <OutputList>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                            <ColumnReference Column="Expr1035" />
                                                          </OutputList>
                                                          <ComputeScalar>
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Column="Expr1035" />
                                                                <ScalarOperator ScalarString="getancestor(XML Reader with XPath filter.[id],(1))">
                                                                  <Intrinsic FunctionName="getancestor">
                                                                    <ScalarOperator>
                                                                      <Identifier>
                                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                                      </Identifier>
                                                                    </ScalarOperator>
                                                                    <ScalarOperator>
                                                                      <Const ConstValue="(1)" />
                                                                    </ScalarOperator>
                                                                  </Intrinsic>
                                                                </ScalarOperator>
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <RelOp AvgRowSize="5521" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="29" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                              <OutputList>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                              </OutputList>
                                                              <TableValuedFunction>
                                                                <DefinedValues>
                                                                  <DefinedValue>
                                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                  </DefinedValue>
                                                                  <DefinedValue>
                                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                                  </DefinedValue>
                                                                </DefinedValues>
                                                                <Object Table="[XML Reader with XPath filter]" />
                                                                <ParameterList>
                                                                  <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                                    <Identifier>
                                                                      <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator ScalarString="(0)">
                                                                    <Const ConstValue="(0)" />
                                                                  </ScalarOperator>
                                                                  <ScalarOperator ScalarString="NULL">
                                                                    <Const ConstValue="NULL" />
                                                                  </ScalarOperator>
                                                                  <ScalarOperator ScalarString="NULL">
                                                                    <Const ConstValue="NULL" />
                                                                  </ScalarOperator>
                                                                </ParameterList>
                                                              </TableValuedFunction>
                                                            </RelOp>
                                                          </ComputeScalar>
                                                        </RelOp>
                                                        <Predicate>
                                                          <ScalarOperator ScalarString="xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(7)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(7))=15">
                                                            <Logical Operation="AND">
                                                              <ScalarOperator>
                                                                <Compare CompareOp="IS NOT">
                                                                  <ScalarOperator>
                                                                    <Intrinsic FunctionName="xsd_cast">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(18)" />
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(7)" />
                                                                      </ScalarOperator>
                                                                    </Intrinsic>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="NULL" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Compare CompareOp="EQ">
                                                                  <ScalarOperator>
                                                                    <Intrinsic FunctionName="xsd_cast">
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Identifier>
                                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                        </Identifier>
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(18)" />
                                                                      </ScalarOperator>
                                                                      <ScalarOperator>
                                                                        <Const ConstValue="(7)" />
                                                                      </ScalarOperator>
                                                                    </Intrinsic>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="15" />
                                                                  </ScalarOperator>
                                                                </Compare>
                                                              </ScalarOperator>
                                                            </Logical>
                                                          </ScalarOperator>
                                                        </Predicate>
                                                      </Filter>
                                                    </RelOp>
                                                  </Sort>
                                                </RelOp>
                                              </Merge>
                                            </RelOp>
                                            <RelOp AvgRowSize="5969" EstimateCPU="0.00249085" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Sort" NodeId="39" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="120.554">
                                              <OutputList>
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                <ColumnReference Column="Expr1033" />
                                              </OutputList>
                                              <MemoryFractions Input="0.480392" Output="0.480392" />
                                              <Sort Distinct="false">
                                                <OrderBy>
                                                  <OrderByColumn Ascending="true">
                                                    <ColumnReference Column="Expr1033" />
                                                  </OrderByColumn>
                                                </OrderBy>
                                                <RelOp AvgRowSize="5969" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="40" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                    <ColumnReference Column="Expr1033" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1033" />
                                                        <ScalarOperator ScalarString="getancestor(XML Reader with XPath filter.[id],(1))">
                                                          <Intrinsic FunctionName="getancestor">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                            <ScalarOperator>
                                                              <Const ConstValue="(1)" />
                                                            </ScalarOperator>
                                                          </Intrinsic>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="5517" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="41" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                      <OutputList>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                      </OutputList>
                                                      <TableValuedFunction>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <Object Table="[XML Reader with XPath filter]" />
                                                        <ParameterList>
                                                          <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                            <Identifier>
                                                              <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                            </Identifier>
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="(0)">
                                                            <Const ConstValue="(0)" />
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="NULL">
                                                            <Const ConstValue="NULL" />
                                                          </ScalarOperator>
                                                          <ScalarOperator ScalarString="NULL">
                                                            <Const ConstValue="NULL" />
                                                          </ScalarOperator>
                                                        </ParameterList>
                                                      </TableValuedFunction>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                              </Sort>
                                            </RelOp>
                                          </Merge>
                                        </RelOp>
                                      </TopSort>
                                    </RelOp>
                                  </ComputeScalar>
                                </RelOp>
                              </StreamAggregate>
                            </RelOp>
                          </NestedLoops>
                        </RelOp>
                        <RelOp AvgRowSize="16" EstimateCPU="1.1E-06" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="Aggregate" NodeId="56" Parallel="true" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="362.622">
                          <OutputList>
                            <ColumnReference Column="Expr1031" />
                          </OutputList>
                          <StreamAggregate>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1031" />
                                <ScalarOperator ScalarString="MIN(CASE WHEN [ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall] IS NULL THEN NULL ELSE CASE WHEN datalength(XML Reader with XPath filter.[value])&gt;=(128) THEN CONVERT_IMPLICIT(numeric(10,8),XML Reader with XPath filter.[lvalue],0) ELSE CONVERT_IMPLICIT(numeric(10,8),XML Reader with XPath filter.[value],0) END END)">
                                  <Aggregate AggType="MIN" Distinct="false">
                                    <ScalarOperator>
                                      <IF>
                                        <Condition>
                                          <ScalarOperator>
                                            <Compare CompareOp="IS">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                </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 Table="[XML Reader with XPath filter]" Column="value" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </Intrinsic>
                                                    </ScalarOperator>
                                                    <ScalarOperator>
                                                      <Const ConstValue="(128)" />
                                                    </ScalarOperator>
                                                  </Compare>
                                                </ScalarOperator>
                                              </Condition>
                                              <Then>
                                                <ScalarOperator>
                                                  <Convert DataType="numeric" Precision="10" Scale="8" Style="0" Implicit="true">
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Convert>
                                                </ScalarOperator>
                                              </Then>
                                              <Else>
                                                <ScalarOperator>
                                                  <Convert DataType="numeric" Precision="10" Scale="8" Style="0" Implicit="true">
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Convert>
                                                </ScalarOperator>
                                              </Else>
                                            </IF>
                                          </ScalarOperator>
                                        </Else>
                                      </IF>
                                    </ScalarOperator>
                                  </Aggregate>
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <RelOp AvgRowSize="5969" EstimateCPU="6.1869E-07" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="57" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="362.622">
                              <OutputList>
                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                <ColumnReference Column="Expr1030" />
                              </OutputList>
                              <ComputeScalar>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1030" />
                                    <ScalarOperator ScalarString="0x58">
                                      <Const ConstValue="0x58" />
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp AvgRowSize="5517" EstimateCPU="0.000130893" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="1" LogicalOp="TopN Sort" NodeId="58" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="362.621">
                                  <OutputList>
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                  </OutputList>
                                  <MemoryFractions Input="0" Output="0.5" />
                                  <TopSort Distinct="false" Rows="1">
                                    <OrderBy>
                                      <OrderByColumn Ascending="true">
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                      </OrderByColumn>
                                    </OrderBy>
                                    <RelOp AvgRowSize="5517" EstimateCPU="0.00603402" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="6.1869" LogicalOp="Inner Join" NodeId="59" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="361.273">
                                      <OutputList>
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                      </OutputList>
                                      <Merge ManyToMany="false">
                                        <InnerSideJoinColumns>
                                          <ColumnReference Column="Expr1037" />
                                        </InnerSideJoinColumns>
                                        <OuterSideJoinColumns>
                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                        </OuterSideJoinColumns>
                                        <Residual>
                                          <ScalarOperator ScalarString="XML Reader with XPath filter.[id]=[Expr1037] AND XML Reader with XPath filter.[id]&lt;=XML Reader with XPath filter.[id] AND [Expr1038]&gt;XML Reader with XPath filter.[id]">
                                            <Logical Operation="AND">
                                              <ScalarOperator>
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Column="Expr1037" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Compare CompareOp="LE">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Compare CompareOp="GT">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Column="Expr1038" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </Logical>
                                          </ScalarOperator>
                                        </Residual>
                                        <RelOp AvgRowSize="913" EstimateCPU="0.00610398" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="3.43717" LogicalOp="Left Semi Join" NodeId="60" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="240.003">
                                          <OutputList>
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                            <ColumnReference Column="Expr1038" />
                                          </OutputList>
                                          <Merge ManyToMany="false">
                                            <InnerSideJoinColumns>
                                              <ColumnReference Column="Expr1039" />
                                            </InnerSideJoinColumns>
                                            <OuterSideJoinColumns>
                                              <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                            </OuterSideJoinColumns>
                                            <Residual>
                                              <ScalarOperator ScalarString="XML Reader with XPath filter.[id]=[Expr1039] AND XML Reader with XPath filter.[id]&lt;=XML Reader with XPath filter.[id] AND [Expr1038]&gt;XML Reader with XPath filter.[id]">
                                                <Logical Operation="AND">
                                                  <ScalarOperator>
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1039" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="LE">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Compare CompareOp="GT">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1038" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Logical>
                                              </ScalarOperator>
                                            </Residual>
                                            <RelOp AvgRowSize="913" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="61" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                              <OutputList>
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                <ColumnReference Column="Expr1038" />
                                              </OutputList>
                                              <ComputeScalar>
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Column="Expr1038" />
                                                    <ScalarOperator ScalarString="getdescendantlimit(XML Reader with XPath filter.[id])">
                                                      <Intrinsic FunctionName="getdescendantlimit">
                                                        <ScalarOperator>
                                                          <Identifier>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                      </Intrinsic>
                                                    </ScalarOperator>
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <RelOp AvgRowSize="461" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="62" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                  </OutputList>
                                                  <TableValuedFunction>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Table="[XML Reader with XPath filter]" />
                                                    <ParameterList>
                                                      <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                        <Identifier>
                                                          <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="(0)">
                                                        <Const ConstValue="(0)" />
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="NULL">
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="NULL">
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                    </ParameterList>
                                                  </TableValuedFunction>
                                                </RelOp>
                                              </ComputeScalar>
                                            </RelOp>
                                            <RelOp AvgRowSize="913" EstimateCPU="0.000414002" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="38.1907" LogicalOp="Sort" NodeId="70" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="120.353">
                                              <OutputList>
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                <ColumnReference Column="Expr1039" />
                                              </OutputList>
                                              <MemoryFractions Input="0.0196078" Output="0.0196078" />
                                              <Sort Distinct="false">
                                                <OrderBy>
                                                  <OrderByColumn Ascending="true">
                                                    <ColumnReference Column="Expr1039" />
                                                  </OrderByColumn>
                                                </OrderBy>
                                                <RelOp AvgRowSize="913" EstimateCPU="0.000376" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="38.1907" LogicalOp="Filter" NodeId="71" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="118.97">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    <ColumnReference Column="Expr1039" />
                                                  </OutputList>
                                                  <Filter StartupExpression="false">
                                                    <RelOp AvgRowSize="5973" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="72" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                                      <OutputList>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                        <ColumnReference Column="Expr1039" />
                                                      </OutputList>
                                                      <ComputeScalar>
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Column="Expr1039" />
                                                            <ScalarOperator ScalarString="getancestor(XML Reader with XPath filter.[id],(1))">
                                                              <Intrinsic FunctionName="getancestor">
                                                                <ScalarOperator>
                                                                  <Identifier>
                                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                                  </Identifier>
                                                                </ScalarOperator>
                                                                <ScalarOperator>
                                                                  <Const ConstValue="(1)" />
                                                                </ScalarOperator>
                                                              </Intrinsic>
                                                            </ScalarOperator>
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <RelOp AvgRowSize="5521" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="73" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                          <OutputList>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                          </OutputList>
                                                          <TableValuedFunction>
                                                            <DefinedValues>
                                                              <DefinedValue>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                              </DefinedValue>
                                                              <DefinedValue>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                              </DefinedValue>
                                                              <DefinedValue>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                              </DefinedValue>
                                                              <DefinedValue>
                                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                              </DefinedValue>
                                                            </DefinedValues>
                                                            <Object Table="[XML Reader with XPath filter]" />
                                                            <ParameterList>
                                                              <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                                <Identifier>
                                                                  <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                                </Identifier>
                                                              </ScalarOperator>
                                                              <ScalarOperator ScalarString="(0)">
                                                                <Const ConstValue="(0)" />
                                                              </ScalarOperator>
                                                              <ScalarOperator ScalarString="NULL">
                                                                <Const ConstValue="NULL" />
                                                              </ScalarOperator>
                                                              <ScalarOperator ScalarString="NULL">
                                                                <Const ConstValue="NULL" />
                                                              </ScalarOperator>
                                                            </ParameterList>
                                                          </TableValuedFunction>
                                                        </RelOp>
                                                      </ComputeScalar>
                                                    </RelOp>
                                                    <Predicate>
                                                      <ScalarOperator ScalarString="xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(7)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(7))=15">
                                                        <Logical Operation="AND">
                                                          <ScalarOperator>
                                                            <Compare CompareOp="IS NOT">
                                                              <ScalarOperator>
                                                                <Intrinsic FunctionName="xsd_cast">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(18)" />
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(7)" />
                                                                  </ScalarOperator>
                                                                </Intrinsic>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="NULL" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Compare CompareOp="EQ">
                                                              <ScalarOperator>
                                                                <Intrinsic FunctionName="xsd_cast">
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Identifier>
                                                                      <ColumnReference Table="[XML Reader with XPath filter]" Column="tid" />
                                                                    </Identifier>
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(18)" />
                                                                  </ScalarOperator>
                                                                  <ScalarOperator>
                                                                    <Const ConstValue="(7)" />
                                                                  </ScalarOperator>
                                                                </Intrinsic>
                                                              </ScalarOperator>
                                                              <ScalarOperator>
                                                                <Const ConstValue="15" />
                                                              </ScalarOperator>
                                                            </Compare>
                                                          </ScalarOperator>
                                                        </Logical>
                                                      </ScalarOperator>
                                                    </Predicate>
                                                  </Filter>
                                                </RelOp>
                                              </Sort>
                                            </RelOp>
                                          </Merge>
                                        </RelOp>
                                        <RelOp AvgRowSize="5969" EstimateCPU="0.00249085" EstimateIO="0.0112613" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Sort" NodeId="83" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="120.554">
                                          <OutputList>
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                            <ColumnReference Column="Expr1037" />
                                          </OutputList>
                                          <MemoryFractions Input="0.480392" Output="0.480392" />
                                          <Sort Distinct="false">
                                            <OrderBy>
                                              <OrderByColumn Ascending="true">
                                                <ColumnReference Column="Expr1037" />
                                              </OrderByColumn>
                                            </OrderBy>
                                            <RelOp AvgRowSize="5969" EstimateCPU="2E-05" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Compute Scalar" NodeId="84" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="118.926">
                                              <OutputList>
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                <ColumnReference Column="Expr1037" />
                                              </OutputList>
                                              <ComputeScalar>
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Column="Expr1037" />
                                                    <ScalarOperator ScalarString="getancestor(XML Reader with XPath filter.[id],(1))">
                                                      <Intrinsic FunctionName="getancestor">
                                                        <ScalarOperator>
                                                          <Identifier>
                                                            <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                          </Identifier>
                                                        </ScalarOperator>
                                                        <ScalarOperator>
                                                          <Const ConstValue="(1)" />
                                                        </ScalarOperator>
                                                      </Intrinsic>
                                                    </ScalarOperator>
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <RelOp AvgRowSize="5517" EstimateCPU="1.004" EstimateIO="0" EstimateRebinds="107.566" EstimateRewinds="9.88345" EstimateRows="200" LogicalOp="Table-valued function" NodeId="85" Parallel="true" PhysicalOp="Table-valued function" EstimatedTotalSubtreeCost="118.923">
                                                  <OutputList>
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                    <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                  </OutputList>
                                                  <TableValuedFunction>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="id" />
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="value" />
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Table="[XML Reader with XPath filter]" Column="lvalue" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Table="[XML Reader with XPath filter]" />
                                                    <ParameterList>
                                                      <ScalarOperator ScalarString="[ESD_Dev].[dbo].[Rainfall_XML].[Rainfall] as [TP].[Rainfall]">
                                                        <Identifier>
                                                          <ColumnReference Database="[ESD_Dev]" Schema="[dbo]" Table="[Rainfall_XML]" Alias="[TP]" Column="Rainfall" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="(0)">
                                                        <Const ConstValue="(0)" />
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="NULL">
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                      <ScalarOperator ScalarString="NULL">
                                                        <Const ConstValue="NULL" />
                                                      </ScalarOperator>
                                                    </ParameterList>
                                                  </TableValuedFunction>
                                                </RelOp>
                                              </ComputeScalar>
                                            </RelOp>
                                          </Sort>
                                        </RelOp>
                                      </Merge>
                                    </RelOp>
                                  </TopSort>
                                </RelOp>
                              </ComputeScalar>
                            </RelOp>
                          </StreamAggregate>
                        </RelOp>
                      </NestedLoops>
                    </RelOp>
                  </Parallelism>
                </RelOp>
              </ComputeScalar>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>