<?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.3068.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="4" StatementEstRows="13470" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="1.42738" StatementText="SELECT customerId, readingId, price, categoryDiscount, readValue, flatDiscount, consumption&#xD;&#xA;		FROM dbo.ViewBillingDataPreliminary&#xD;&#xA;		ORDER BY customerId, readingId&#xD;&#xA;&#xD;" 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 DegreeOfParallelism="0" MemoryGrant="405" CachedPlanSize="175" CompileTime="256" CompileCPU="255" CompileMemory="1360">
            <RelOp AvgRowSize="76" EstimateCPU="0.848216" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13470" LogicalOp="Sort" NodeId="1" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="1.42738">
              <OutputList>
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readingId" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readValue" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="consumption" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="price" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
              </OutputList>
              <MemoryFractions Input="1" Output="1" />
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="8387" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Sort Distinct="false">
                <OrderBy>
                  <OrderByColumn Ascending="true">
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                  </OrderByColumn>
                  <OrderByColumn Ascending="true">
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readingId" />
                  </OrderByColumn>
                </OrderBy>
                <RelOp AvgRowSize="76" EstimateCPU="0.155443" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="13470" LogicalOp="Inner Join" NodeId="2" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.567901">
                  <OutputList>
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readingId" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readValue" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="consumption" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="price" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                  </OutputList>
                  <MemoryFractions Input="0" Output="0" />
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="8387" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <Hash>
                    <DefinedValues />
                    <HashKeysBuild>
                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                    </HashKeysBuild>
                    <HashKeysProbe>
                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="meterId" />
                    </HashKeysProbe>
                    <ProbeResidual>
                      <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Reading].[meterId]=[CRMdatabase].[dbo].[Contract_Meter].[meterId]">
                        <Compare CompareOp="EQ">
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="meterId" />
                            </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                            </Identifier>
                          </ScalarOperator>
                        </Compare>
                      </ScalarOperator>
                    </ProbeResidual>
                    <RelOp AvgRowSize="58" EstimateCPU="0.0237955" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1321.49" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.295217">
                      <OutputList>
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="price" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                      </OutputList>
                      <MemoryFractions Input="0" Output="0" />
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="751" ActualEndOfScans="1" ActualExecutions="1" />
                      </RunTimeInformation>
                      <Hash>
                        <DefinedValues />
                        <HashKeysBuild>
                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="serviceId" />
                        </HashKeysBuild>
                        <HashKeysProbe>
                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                        </HashKeysProbe>
                        <ProbeResidual>
                          <ScalarOperator ScalarString="[CRMdatabase].[dbo].[SevicesPricelist].[serviceId]=[CRMdatabase].[dbo].[Services].[serviceId]">
                            <Compare CompareOp="EQ">
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="serviceId" />
                                </Identifier>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Identifier>
                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                                </Identifier>
                              </ScalarOperator>
                            </Compare>
                          </ScalarOperator>
                        </ProbeResidual>
                        <RelOp AvgRowSize="20" EstimateCPU="0.0001636" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032886">
                          <OutputList>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="price" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="serviceId" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="price" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Column="serviceId" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[SevicesPricelist]" Index="[PK_SevicesPricelist]" />
                          </IndexScan>
                        </RelOp>
                        <RelOp AvgRowSize="53" EstimateCPU="0.0228611" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="660.746" LogicalOp="Inner Join" NodeId="5" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.268129">
                          <OutputList>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                          </OutputList>
                          <MemoryFractions Input="0" Output="0" />
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="751" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <Hash>
                            <DefinedValues />
                            <HashKeysBuild>
                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                            </HashKeysBuild>
                            <HashKeysProbe>
                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="serviceId" />
                            </HashKeysProbe>
                            <ProbeResidual>
                              <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Meter].[serviceId]=[CRMdatabase].[dbo].[Services].[serviceId]">
                                <Compare CompareOp="EQ">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="serviceId" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </ProbeResidual>
                            <RelOp AvgRowSize="11" EstimateCPU="0.0001625" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5" LogicalOp="Clustered Index Scan" NodeId="6" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032875">
                              <OutputList>
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
                              </RunTimeInformation>
                              <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Column="serviceId" />
                                  </DefinedValue>
                                </DefinedValues>
                                <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Services]" Index="[PK_Services]" />
                              </IndexScan>
                            </RelOp>
                            <RelOp AvgRowSize="53" EstimateCPU="0.0502551" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="660.746" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.241978">
                              <OutputList>
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="serviceId" />
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                              </OutputList>
                              <MemoryFractions Input="0" Output="0" />
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="799" ActualEndOfScans="1" ActualExecutions="1" />
                              </RunTimeInformation>
                              <Hash>
                                <DefinedValues />
                                <HashKeysBuild>
                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                </HashKeysBuild>
                                <HashKeysProbe>
                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="meterId" />
                                </HashKeysProbe>
                                <ProbeResidual>
                                  <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Contract_Meter].[meterId]=[CRMdatabase].[dbo].[Meter].[meterId]">
                                    <Compare CompareOp="EQ">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                        </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="meterId" />
                                        </Identifier>
                                      </ScalarOperator>
                                    </Compare>
                                  </ScalarOperator>
                                </ProbeResidual>
                                <RelOp AvgRowSize="49" EstimateCPU="0.0493179" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="660.746" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.176214">
                                  <OutputList>
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                                  </OutputList>
                                  <MemoryFractions Input="0" Output="0" />
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="799" ActualEndOfScans="1" ActualExecutions="1" />
                                  </RunTimeInformation>
                                  <Hash>
                                    <DefinedValues />
                                    <HashKeysBuild>
                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                    </HashKeysBuild>
                                    <HashKeysProbe>
                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="contractId" />
                                    </HashKeysProbe>
                                    <ProbeResidual>
                                      <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Contract].[contractId]=[CRMdatabase].[dbo].[Contract_Meter].[contractId]">
                                        <Compare CompareOp="EQ">
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                            </Identifier>
                                          </ScalarOperator>
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="contractId" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </Compare>
                                      </ScalarOperator>
                                    </ProbeResidual>
                                    <RelOp AvgRowSize="49" EstimateCPU="0.023028" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="672.342" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.120509">
                                      <OutputList>
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                                      </OutputList>
                                      <MemoryFractions Input="0" Output="0" />
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="774" ActualEndOfScans="1" ActualExecutions="1" />
                                      </RunTimeInformation>
                                      <Hash>
                                        <DefinedValues />
                                        <HashKeysBuild>
                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="customerCategoryId" />
                                        </HashKeysBuild>
                                        <HashKeysProbe>
                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerCategoryId" />
                                        </HashKeysProbe>
                                        <ProbeResidual>
                                          <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Contract].[customerCategoryId]=[CRMdatabase].[dbo].[CustomerCategory].[customerCategoryId]">
                                            <Compare CompareOp="EQ">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerCategoryId" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="customerCategoryId" />
                                                </Identifier>
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </ProbeResidual>
                                        <RelOp AvgRowSize="29" EstimateCPU="0.0001636" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="6" LogicalOp="Clustered Index Scan" NodeId="10" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032886">
                                          <OutputList>
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="customerCategoryId" />
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                                          </OutputList>
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />
                                          </RunTimeInformation>
                                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="customerCategoryId" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="categoryDiscount" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Column="flatDiscount" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerCategory]" Index="[PK_CustomerCategory]" />
                                          </IndexScan>
                                        </RelOp>
                                        <RelOp AvgRowSize="35" EstimateCPU="0.0356461" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="672.342" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0941898">
                                          <OutputList>
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerCategoryId" />
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                          </OutputList>
                                          <MemoryFractions Input="0" Output="0" />
                                          <RunTimeInformation>
                                            <RunTimeCountersPerThread Thread="0" ActualRows="775" ActualEndOfScans="1" ActualExecutions="1" />
                                          </RunTimeInformation>
                                          <Hash>
                                            <DefinedValues />
                                            <HashKeysBuild>
                                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                            </HashKeysBuild>
                                            <HashKeysProbe>
                                              <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                            </HashKeysProbe>
                                            <ProbeResidual>
                                              <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Customer].[customerId]=[CRMdatabase].[dbo].[Contract].[customerId]">
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </ProbeResidual>
                                            <RelOp AvgRowSize="15" EstimateCPU="0.0233325" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="728" LogicalOp="Inner Join" NodeId="12" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="0.0484803">
                                              <OutputList>
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                              </OutputList>
                                              <MemoryFractions Input="0" Output="0" />
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="728" ActualEndOfScans="1" ActualExecutions="1" />
                                              </RunTimeInformation>
                                              <Hash>
                                                <DefinedValues />
                                                <HashKeysBuild>
                                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerType]" Column="customerTypeId" />
                                                </HashKeysBuild>
                                                <HashKeysProbe>
                                                  <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerTypeId" />
                                                </HashKeysProbe>
                                                <ProbeResidual>
                                                  <ScalarOperator ScalarString="[CRMdatabase].[dbo].[Customer].[customerTypeId]=[CRMdatabase].[dbo].[CustomerType].[customerTypeId]">
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerTypeId" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerType]" Column="customerTypeId" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </ProbeResidual>
                                                <RelOp AvgRowSize="11" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Clustered Index Scan" NodeId="13" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032842">
                                                  <OutputList>
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerType]" Column="customerTypeId" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
                                                  </RunTimeInformation>
                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerType]" Column="customerTypeId" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[CustomerType]" Index="[PK_CustomerType]" />
                                                  </IndexScan>
                                                </RelOp>
                                                <RelOp AvgRowSize="19" EstimateCPU="0.0009578" EstimateIO="0.0209028" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="728" LogicalOp="Clustered Index Scan" NodeId="14" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0218606">
                                                  <OutputList>
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerTypeId" />
                                                  </OutputList>
                                                  <RunTimeInformation>
                                                    <RunTimeCountersPerThread Thread="0" ActualRows="728" ActualEndOfScans="1" ActualExecutions="1" />
                                                  </RunTimeInformation>
                                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerId" />
                                                      </DefinedValue>
                                                      <DefinedValue>
                                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Column="customerTypeId" />
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Customer]" Index="[PK_Customer]" />
                                                  </IndexScan>
                                                </RelOp>
                                              </Hash>
                                            </RelOp>
                                            <RelOp AvgRowSize="27" EstimateCPU="0.0010095" EstimateIO="0.00905093" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="775" LogicalOp="Clustered Index Scan" NodeId="16" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0100604">
                                              <OutputList>
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                                <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerCategoryId" />
                                              </OutputList>
                                              <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="775" ActualEndOfScans="1" ActualExecutions="1" />
                                              </RunTimeInformation>
                                              <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="contractId" />
                                                  </DefinedValue>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerId" />
                                                  </DefinedValue>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Column="customerCategoryId" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract]" Index="[PK_Contract]" />
                                              </IndexScan>
                                            </RelOp>
                                          </Hash>
                                        </RelOp>
                                      </Hash>
                                    </RelOp>
                                    <RelOp AvgRowSize="23" EstimateCPU="0.001037" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="800" LogicalOp="Clustered Index Scan" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00638422">
                                      <OutputList>
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="contractId" />
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                      </OutputList>
                                      <RunTimeInformation>
                                        <RunTimeCountersPerThread Thread="0" ActualRows="800" ActualEndOfScans="1" ActualExecutions="1" />
                                      </RunTimeInformation>
                                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="contractId" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Column="meterId" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Contract_Meter]" Index="[PK_Contract_Meter]" />
                                      </IndexScan>
                                    </RelOp>
                                  </Hash>
                                </RelOp>
                                <RelOp AvgRowSize="19" EstimateCPU="0.0012691" EstimateIO="0.0142361" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1011" LogicalOp="Clustered Index Scan" NodeId="21" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0155052">
                                  <OutputList>
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="meterId" />
                                    <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="serviceId" />
                                  </OutputList>
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="1011" ActualEndOfScans="1" ActualExecutions="1" />
                                  </RunTimeInformation>
                                  <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                    <DefinedValues>
                                      <DefinedValue>
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="meterId" />
                                      </DefinedValue>
                                      <DefinedValue>
                                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Column="serviceId" />
                                      </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Meter]" Index="[PK_Meter]" />
                                  </IndexScan>
                                </RelOp>
                              </Hash>
                            </RelOp>
                          </Hash>
                        </RelOp>
                      </Hash>
                    </RelOp>
                    <RelOp AvgRowSize="41" EstimateCPU="0.0104101" EstimateIO="0.106829" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="9321" LogicalOp="Clustered Index Scan" NodeId="25" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.117239">
                      <OutputList>
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readingId" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="meterId" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readValue" />
                        <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="consumption" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="9321" ActualEndOfScans="1" ActualExecutions="1" />
                      </RunTimeInformation>
                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readingId" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="meterId" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="readValue" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Column="consumption" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[CRMdatabase]" Schema="[dbo]" Table="[Reading]" Index="[PK_Reading]" />
                      </IndexScan>
                    </RelOp>
                  </Hash>
                </RelOp>
              </Sort>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>