udpProductTaxRateGet NEW

<?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.2" Build="12.0.2000.8" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="10" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="70" StatementSubTreeCost="0.00657344" StatementText="SELECT TOP 1  ISNULL(pst.TaxCode, '') as TaxCode&#xD;&#xA;	        , ISNULL(pst.TaxRate, 0) as TaxRate&#xD;&#xA;FROM	dbo.[ProductShipTax] pst&#xD;&#xA;WHERE EXISTS (&#xD;&#xA;&#xD;&#xA;					SELECT	TaxRegionId&#xD;&#xA;					FROM	dbo.[ShipTaxAddress]&#xD;&#xA;					WHERE	[CountryCode] = @countryCode&#xD;&#xA;					AND		[AddressFormatID] = @addressFormatID&#xD;&#xA;&#xD;&#xA;					AND ([MatchAddressLine1] = @AddressLine1 OR ([MatchAddressLine1] IS NULL AND @AddressLine1 IS NULL) )&#xD;&#xA;					AND ([MatchAddressLine2] = @AddressLine2 OR ([MatchAddressLine2] IS NULL AND @AddressLine2 IS NULL) )&#xD;&#xA;					AND ([MatchAddressLine3] = @AddressLine3 OR ([MatchAddressLine3] IS NULL AND @AddressLine3 IS NULL) )&#xD;&#xA;					AND ([MatchAddressLine4] = @AddressLine4 OR ([MatchAddressLine4] IS NULL AND @AddressLine4 IS NULL) )&#xD;&#xA;					AND ([MatchAddressLine5] = @AddressLine5 OR ([MatchAddressLine5] IS NULL AND @AddressLine5 IS NULL) )&#xD;&#xA;					AND ([MatchAddressLine6] = @AddressLine6 OR ([MatchAddressLine6] IS NULL AND @AddressLine6 IS NULL) )&#xD;&#xA;&#xD;&#xA;					AND (@postalcode = [MatchPostalCode]     OR ([MatchPostalCode]   IS NULL AND @postalcode   IS NULL) )&#xD;&#xA;					AND  TaxRegionId = pst.TaxRegionId &#xD;&#xA;&#xD;&#xA;&#xD;&#xA;)&#xD;&#xA;AND pst.[ItemNo] = @itemNo&#xD;&#xA;AND	@calculateDate BETWEEN pst.[DateFrom] AND pst.[DateTo]" StatementType="SELECT" QueryHash="0xC50B06E08A83A95A" QueryPlanHash="0x3CE584F78105D09D" RetrievedFromCache="true">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="1" CachedPlanSize="48" CompileTime="5" CompileCPU="5" CompileMemory="824">
            <MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" />
            <OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="417953" EstimatedPagesCached="104488" EstimatedAvailableDegreeOfParallelism="2" />
            <RelOp AvgRowSize="30" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Top" NodeId="0" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.00657344">
              <OutputList>
                <ColumnReference Column="Expr1004" />
                <ColumnReference Column="Expr1005" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <Top RowCount="false" IsPercent="false" WithTies="false">
                <TopExpression>
                  <ScalarOperator ScalarString="(1)">
                    <Const ConstValue="(1)" />
                  </ScalarOperator>
                </TopExpression>
                <RelOp AvgRowSize="30" EstimateCPU="4.22593E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="1" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.00657334">
                  <OutputList>
                    <ColumnReference Column="Expr1004" />
                    <ColumnReference Column="Expr1005" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                  </RunTimeInformation>
                  <NestedLoops Optimized="false">
                    <Predicate>
                      <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[TaxRegionId]=[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxRegionId] as [pst].[TaxRegionId]">
                        <Compare CompareOp="EQ">
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" />
                            </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" />
                            </Identifier>
                          </ScalarOperator>
                        </Compare>
                      </ScalarOperator>
                    </Predicate>
                    <RelOp AvgRowSize="34" EstimateCPU="1.01099E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00328368">
                      <OutputList>
                        <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" />
                        <ColumnReference Column="Expr1004" />
                        <ColumnReference Column="Expr1005" />
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1004" />
                            <ScalarOperator ScalarString="isnull([US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxCode] as [pst].[TaxCode],'')">
                              <Intrinsic FunctionName="isnull">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" />
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Const ConstValue="''" />
                                </ScalarOperator>
                              </Intrinsic>
                            </ScalarOperator>
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Column="Expr1005" />
                            <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[TaxRate] as [pst].[TaxRate]">
                              <Identifier>
                                <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" />
                              </Identifier>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp AvgRowSize="38" EstimateCPU="0.000158112" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Inner Join" NodeId="3" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="60057">
                          <OutputList>
                            <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" />
                            <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" />
                            <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                          </RunTimeInformation>
                          <NestedLoops Optimized="false">
                            <OuterReferences>
                              <ColumnReference Column="Expr1007" />
                              <ColumnReference Column="Expr1008" />
                              <ColumnReference Column="Expr1006" />
                            </OuterReferences>
                            <RelOp AvgRowSize="19" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0">
                              <OutputList>
                                <ColumnReference Column="Expr1007" />
                                <ColumnReference Column="Expr1008" />
                                <ColumnReference Column="Expr1006" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                              </RunTimeInformation>
                              <ComputeScalar>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ValueVector>
                                      <ColumnReference Column="Expr1007" />
                                      <ColumnReference Column="Expr1008" />
                                      <ColumnReference Column="Expr1006" />
                                    </ValueVector>
                                    <ScalarOperator ScalarString="GetRangeWithMismatchedTypes(NULL,[@calculateDate],(42))">
                                      <Intrinsic FunctionName="GetRangeWithMismatchedTypes">
                                        <ScalarOperator>
                                          <Const ConstValue="NULL" />
                                        </ScalarOperator>
                                        <ScalarOperator>
                                          <Identifier>
                                            <ColumnReference Column="@calculateDate" />
                                          </Identifier>
                                        </ScalarOperator>
                                        <ScalarOperator>
                                          <Const ConstValue="(42)" />
                                        </ScalarOperator>
                                      </Intrinsic>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <RelOp AvgRowSize="0" EstimateCPU="0" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Constant Scan" NodeId="5" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0">
                                  <OutputList />
                                  <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                                  </RunTimeInformation>
                                  <ConstantScan />
                                </RelOp>
                              </ComputeScalar>
                            </RelOp>
                            <RelOp AvgRowSize="38" EstimateCPU="0.000158112" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="9" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="60057">
                              <OutputList>
                                <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" />
                                <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" />
                                <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" />
                              </OutputList>
                              <RunTimeInformation>
                                <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                              </RunTimeInformation>
                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRate" />
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxCode" />
                                  </DefinedValue>
                                  <DefinedValue>
                                    <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="TaxRegionId" />
                                  </DefinedValue>
                                </DefinedValues>
                                <Object Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Index="[IX_ProductShipTax_ITemNo_DateFrom_DateTo]" Alias="[pst]" IndexKind="NonClustered" Storage="RowStore" />
                                <SeekPredicates>
                                  <SeekPredicateNew>
                                    <SeekKeys>
                                      <Prefix ScanType="EQ">
                                        <RangeColumns>
                                          <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="ItemNo" />
                                        </RangeColumns>
                                        <RangeExpressions>
                                          <ScalarOperator ScalarString="[@itemNo]">
                                            <Identifier>
                                              <ColumnReference Column="@itemNo" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </RangeExpressions>
                                      </Prefix>
                                      <StartRange ScanType="GT">
                                        <RangeColumns>
                                          <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateFrom" />
                                        </RangeColumns>
                                        <RangeExpressions>
                                          <ScalarOperator ScalarString="[Expr1007]">
                                            <Identifier>
                                              <ColumnReference Column="Expr1007" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </RangeExpressions>
                                      </StartRange>
                                      <EndRange ScanType="LT">
                                        <RangeColumns>
                                          <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateFrom" />
                                        </RangeColumns>
                                        <RangeExpressions>
                                          <ScalarOperator ScalarString="[Expr1008]">
                                            <Identifier>
                                              <ColumnReference Column="Expr1008" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </RangeExpressions>
                                      </EndRange>
                                    </SeekKeys>
                                  </SeekPredicateNew>
                                </SeekPredicates>
                                <Predicate>
                                  <ScalarOperator ScalarString="[@calculateDate]&lt;=[US16HSMMProduct_AFTER_CHANGES].[dbo].[ProductShipTax].[DateTo] as [pst].[DateTo]">
                                    <Compare CompareOp="LE">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Column="@calculateDate" />
                                        </Identifier>
                                      </ScalarOperator>
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ProductShipTax]" Alias="[pst]" Column="DateTo" />
                                        </Identifier>
                                      </ScalarOperator>
                                    </Compare>
                                  </ScalarOperator>
                                </Predicate>
                              </IndexScan>
                            </RelOp>
                          </NestedLoops>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                    <RelOp AvgRowSize="277" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row" EstimateRows="1" LogicalOp="Index Seek" NodeId="15" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="185">
                      <OutputList>
                        <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" />
                      </OutputList>
                      <RunTimeInformation>
                        <RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
                      </RunTimeInformation>
                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false" Storage="RowStore">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="TaxRegionId" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Index="[IDX_ShipTaxAddress_ShipTaxAddress]" IndexKind="NonClustered" Storage="RowStore" />
                        <SeekPredicates>
                          <SeekPredicateNew>
                            <SeekKeys>
                              <Prefix ScanType="EQ">
                                <RangeColumns>
                                  <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="CountryCode" />
                                  <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="AddressFormatId" />
                                  <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchPostalCode" />
                                </RangeColumns>
                                <RangeExpressions>
                                  <ScalarOperator ScalarString="[@countryCode]">
                                    <Identifier>
                                      <ColumnReference Column="@countryCode" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator ScalarString="[@addressFormatID]">
                                    <Identifier>
                                      <ColumnReference Column="@addressFormatID" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator ScalarString="[@postalCode]">
                                    <Identifier>
                                      <ColumnReference Column="@postalCode" />
                                    </Identifier>
                                  </ScalarOperator>
                                </RangeExpressions>
                              </Prefix>
                            </SeekKeys>
                          </SeekPredicateNew>
                        </SeekPredicates>
                        <Predicate>
                          <ScalarOperator ScalarString="[US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine1] = [@addressLine1] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine2] = [@addressLine2] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine3] = [@addressLine3] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine4] = [@addressLine4] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine5] = [@addressLine5] AND [US16HSMMProduct_AFTER_CHANGES].[dbo].[ShipTaxAddress].[MatchAddressLine6] = [@addressLine6]">
                            <Logical Operation="AND">
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine1" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine1" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine2" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine2" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine3" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine3" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine4" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine4" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine5" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine5" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Compare CompareOp="IS">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[US16HSMMProduct_AFTER_CHANGES]" Schema="[dbo]" Table="[ShipTaxAddress]" Column="MatchAddressLine6" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="@addressLine6" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Logical>
                          </ScalarOperator>
                        </Predicate>
                      </IndexScan>
                    </RelOp>
                  </NestedLoops>
                </RelOp>
              </Top>
            </RelOp>
            <ParameterList>
              <ColumnReference Column="@calculateDate" ParameterCompiledValue="'2016-08-08 13:01:46.760'" ParameterRuntimeValue="'2016-08-08 13:01:46.760'" />
              <ColumnReference Column="@itemNo" ParameterCompiledValue="'31997299'" ParameterRuntimeValue="'31997299'" />
              <ColumnReference Column="@postalCode" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressLine6" ParameterCompiledValue="N'FL'" ParameterRuntimeValue="N'FL'" />
              <ColumnReference Column="@addressLine5" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressLine4" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressLine3" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressLine2" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressLine1" ParameterCompiledValue="N''" ParameterRuntimeValue="NULL" />
              <ColumnReference Column="@addressFormatID" ParameterCompiledValue="(2)" ParameterRuntimeValue="(2)" />
              <ColumnReference Column="@countryCode" ParameterCompiledValue="'US'" ParameterRuntimeValue="'US'" />
            </ParameterList>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>