<?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.4053.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="2" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.313933" StatementText="DECLARE @PORACPlanOptions TABLE&#xD;&#xA;	(&#xD;&#xA;		PlanOptionID VARCHAR(50) PRIMARY KEY,&#xD;&#xA;		UserID INT,&#xD;&#xA;		RateId INT,&#xD;&#xA;		OOPCostID INT&#xD;&#xA;	)&#xD;&#xA;&#xD;&#xA;UPDATE  UserPlanOption      &#xD;&#xA;SET     RateID = r.ID     &#xD;&#xA;FROM    [User] u &#xD;&#xA;LEFT JOIN Rate r ON r.FamilyTierID = u.FamilyTierID      &#xD;&#xA;WHERE   UserPlanOption.PlanOptionID NOT IN (SELECT ppo.PlanOptionID FROM                      &#xD;&#xA;@PORACPlanOptions ppo) AND         &#xD;&#xA;u.ID = 1 AND u.ID = UserPlanOption.UserID AND         &#xD;&#xA;r.PlanOptionID = UserPlanOption.PlanOptionID AND         &#xD;&#xA;r.Criterion1 = dbo.GetPlanOptionAreaID_36(62, '62_1', 6, '02052', 0)&#xD;&#xA;	" StatementType="UPDATE">
          <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="34" CompileTime="30" CompileCPU="30" CompileMemory="776">
            <MissingIndexes>
              <MissingIndexGroup Impact="87.1972">
                <MissingIndex Database="[Chooser2]" Schema="[dbo]" Table="[Rate]">
                  <ColumnGroup Usage="EQUALITY">
                    <Column Name="[FamilyTierID]" ColumnId="3" />
                  </ColumnGroup>
                  <ColumnGroup Usage="INCLUDE">
                    <Column Name="[ID]" ColumnId="1" />
                    <Column Name="[PlanOptionID]" ColumnId="2" />
                    <Column Name="[Criterion1]" ColumnId="11" />
                  </ColumnGroup>
                </MissingIndex>
              </MissingIndexGroup>
            </MissingIndexes>
            <RelOp AvgRowSize="9" EstimateCPU="1.8E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Assert" NodeId="1" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.313933">
              <OutputList />
              <Assert StartupExpression="false">
                <RelOp AvgRowSize="9" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Semi Join" NodeId="2" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.313933">
                  <OutputList>
                    <ColumnReference Column="Expr1020" />
                  </OutputList>
                  <NestedLoops Optimized="false">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Column="Expr1020" />
                      </DefinedValue>
                    </DefinedValues>
                    <OuterReferences>
                      <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="RateID" />
                    </OuterReferences>
                    <ProbeColumn>
                      <ColumnReference Column="Expr1020" />
                    </ProbeColumn>
                    <RelOp AvgRowSize="11" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Update" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Update" EstimatedTotalSubtreeCost="0.310646">
                      <OutputList>
                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="RateID" />
                      </OutputList>
                      <Update>
                        <Object Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Index="[PK_UserPlanOption_1]" />
                        <SetPredicate>
                          <ScalarOperator ScalarString="[Chooser2].[dbo].[UserPlanOption].[RateID] = [Chooser2].[dbo].[Rate].[ID] as [r].[ID]">
                            <ScalarExpressionList />
                          </ScalarOperator>
                        </SetPredicate>
                        <RelOp AvgRowSize="26" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Top" NodeId="4" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="0.300645">
                          <OutputList>
                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                          </OutputList>
                          <Top RowCount="true" IsPercent="false" WithTies="false">
                            <TopExpression>
                              <ScalarOperator ScalarString="(0)">
                                <Const ConstValue="(0)" />
                              </ScalarOperator>
                            </TopExpression>
                            <RelOp AvgRowSize="26" EstimateCPU="0.000100026" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distinct Sort" NodeId="5" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.300645">
                              <OutputList>
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                              </OutputList>
                              <MemoryFractions Input="1" Output="1" />
                              <Sort Distinct="true">
                                <OrderBy>
                                  <OrderByColumn Ascending="true">
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                  </OrderByColumn>
                                </OrderBy>
                                <RelOp AvgRowSize="26" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Anti Semi Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.289283">
                                  <OutputList>
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                  </OutputList>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="26" EstimateCPU="8.55394E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="7" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.285996">
                                      <OutputList>
                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                      </OutputList>
                                      <NestedLoops Optimized="false">
                                        <OuterReferences>
                                          <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                        </OuterReferences>
                                        <RelOp AvgRowSize="21" EstimateCPU="0.00197943" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.0464" LogicalOp="Inner Join" NodeId="8" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.28089">
                                          <OutputList>
                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                          </OutputList>
                                          <NestedLoops Optimized="false">
                                            <Predicate>
                                              <ScalarOperator ScalarString="[Chooser2].[dbo].[Rate].[FamilyTierID] as [r].[FamilyTierID]=[Chooser2].[dbo].[User].[FamilyTierID] as [u].[FamilyTierID]">
                                                <Compare CompareOp="EQ">
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="FamilyTierID" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[User]" Alias="[u]" Column="FamilyTierID" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </Predicate>
                                            <RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="9" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831">
                                              <OutputList>
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[User]" Alias="[u]" Column="FamilyTierID" />
                                              </OutputList>
                                              <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[User]" Alias="[u]" Column="FamilyTierID" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[Chooser2]" Schema="[dbo]" Table="[User]" Index="[PK_User]" Alias="[u]" TableReferenceId="-1" />
                                                <SeekPredicates>
                                                  <SeekPredicate>
                                                    <Prefix ScanType="EQ">
                                                      <RangeColumns>
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[User]" Alias="[u]" Column="ID" />
                                                      </RangeColumns>
                                                      <RangeExpressions>
                                                        <ScalarOperator ScalarString="(1)">
                                                          <Const ConstValue="(1)" />
                                                        </ScalarOperator>
                                                      </RangeExpressions>
                                                    </Prefix>
                                                  </SeekPredicate>
                                                </SeekPredicates>
                                              </IndexScan>
                                            </RelOp>
                                            <RelOp AvgRowSize="29" EstimateCPU="0.0194716" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="473.548" LogicalOp="Filter" NodeId="10" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.275485">
                                              <OutputList>
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="FamilyTierID" />
                                              </OutputList>
                                              <Filter StartupExpression="false">
                                                <RelOp AvgRowSize="33" EstimateCPU="0.0019869" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="19869" LogicalOp="Compute Scalar" NodeId="11" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.256014">
                                                  <OutputList>
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="FamilyTierID" />
                                                    <ColumnReference Column="Expr1018" />
                                                  </OutputList>
                                                  <ComputeScalar>
                                                    <DefinedValues>
                                                      <DefinedValue>
                                                        <ColumnReference Column="Expr1018" />
                                                        <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Chooser2].[dbo].[Rate].[Criterion1] as [r].[Criterion1],0)">
                                                          <Convert DataType="int" Style="0" Implicit="true">
                                                            <ScalarOperator>
                                                              <Identifier>
                                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="Criterion1" />
                                                              </Identifier>
                                                            </ScalarOperator>
                                                          </Convert>
                                                        </ScalarOperator>
                                                      </DefinedValue>
                                                    </DefinedValues>
                                                    <RelOp AvgRowSize="46" EstimateCPU="0.0220129" EstimateIO="0.232014" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="19869" LogicalOp="Clustered Index Scan" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.254027">
                                                      <OutputList>
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="FamilyTierID" />
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="Criterion1" />
                                                      </OutputList>
                                                      <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                        <DefinedValues>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="ID" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="FamilyTierID" />
                                                          </DefinedValue>
                                                          <DefinedValue>
                                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="Criterion1" />
                                                          </DefinedValue>
                                                        </DefinedValues>
                                                        <Object Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Index="[PK_Rates_1]" Alias="[r]" TableReferenceId="-1" />
                                                      </IndexScan>
                                                    </RelOp>
                                                  </ComputeScalar>
                                                </RelOp>
                                                <Predicate>
                                                  <ScalarOperator ScalarString="[Expr1018]=[Chooser2].[dbo].[GetPlanOptionAreaID_36]((62),'62_1','6','02052',(0))">
                                                    <Compare CompareOp="EQ">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Column="Expr1018" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                        <UserDefinedFunction FunctionName="[Chooser2].[dbo].[GetPlanOptionAreaID_36]">
                                                          <ScalarOperator>
                                                            <Const ConstValue="(62)" />
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="'62_1'" />
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="'6'" />
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="'02052'" />
                                                          </ScalarOperator>
                                                          <ScalarOperator>
                                                            <Const ConstValue="(0)" />
                                                          </ScalarOperator>
                                                        </UserDefinedFunction>
                                                      </ScalarOperator>
                                                    </Compare>
                                                  </ScalarOperator>
                                                </Predicate>
                                              </Filter>
                                            </RelOp>
                                          </NestedLoops>
                                        </RelOp>
                                        <RelOp AvgRowSize="22" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.0464" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="18" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.00509764">
                                          <OutputList>
                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                            <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                          </OutputList>
                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Index="[PK_UserPlanOption_1]" TableReferenceId="-1" />
                                            <SeekPredicates>
                                              <SeekPredicate>
                                                <Prefix ScanType="EQ">
                                                  <RangeColumns>
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="UserID" />
                                                  </RangeColumns>
                                                  <RangeExpressions>
                                                    <ScalarOperator ScalarString="[Chooser2].[dbo].[Rate].[PlanOptionID] as [r].[PlanOptionID]">
                                                      <Identifier>
                                                        <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Alias="[r]" Column="PlanOptionID" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                    <ScalarOperator ScalarString="(1)">
                                                      <Const ConstValue="(1)" />
                                                    </ScalarOperator>
                                                  </RangeExpressions>
                                                </Prefix>
                                              </SeekPredicate>
                                            </SeekPredicates>
                                          </IndexScan>
                                        </RelOp>
                                      </NestedLoops>
                                    </RelOp>
                                    <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831">
                                      <OutputList />
                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                                        <DefinedValues />
                                        <Object Table="[@PORACPlanOptions]" Index="[PK__#226010D3__2354350C]" Alias="[ppo]" TableReferenceId="-1" />
                                        <SeekPredicates>
                                          <SeekPredicate>
                                            <Prefix ScanType="EQ">
                                              <RangeColumns>
                                                <ColumnReference Table="@PORACPlanOptions" Alias="[ppo]" Column="PlanOptionID" />
                                              </RangeColumns>
                                              <RangeExpressions>
                                                <ScalarOperator ScalarString="[Chooser2].[dbo].[UserPlanOption].[PlanOptionID]">
                                                  <Identifier>
                                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="PlanOptionID" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </RangeExpressions>
                                            </Prefix>
                                          </SeekPredicate>
                                        </SeekPredicates>
                                      </IndexScan>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                              </Sort>
                            </RelOp>
                          </Top>
                        </RelOp>
                      </Update>
                    </RelOp>
                    <RelOp AvgRowSize="9" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="21" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831">
                      <OutputList />
                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
                        <DefinedValues />
                        <Object Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Index="[PK_Rates_1]" />
                        <SeekPredicates>
                          <SeekPredicate>
                            <Prefix ScanType="EQ">
                              <RangeColumns>
                                <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[Rate]" Column="ID" />
                              </RangeColumns>
                              <RangeExpressions>
                                <ScalarOperator ScalarString="[Chooser2].[dbo].[UserPlanOption].[RateID]">
                                  <Identifier>
                                    <ColumnReference Database="[Chooser2]" Schema="[dbo]" Table="[UserPlanOption]" Column="RateID" />
                                  </Identifier>
                                </ScalarOperator>
                              </RangeExpressions>
                            </Prefix>
                          </SeekPredicate>
                        </SeekPredicates>
                      </IndexScan>
                    </RelOp>
                  </NestedLoops>
                </RelOp>
                <Predicate>
                  <ScalarOperator ScalarString="CASE WHEN [Expr1020] IS NULL THEN (0) ELSE NULL END">
                    <IF>
                      <Condition>
                        <ScalarOperator>
                          <Logical Operation="IS NULL">
                            <ScalarOperator>
                              <Identifier>
                                <ColumnReference Column="Expr1020" />
                              </Identifier>
                            </ScalarOperator>
                          </Logical>
                        </ScalarOperator>
                      </Condition>
                      <Then>
                        <ScalarOperator>
                          <Const ConstValue="(0)" />
                        </ScalarOperator>
                      </Then>
                      <Else>
                        <ScalarOperator>
                          <Const ConstValue="NULL" />
                        </ScalarOperator>
                      </Else>
                    </IF>
                  </ScalarOperator>
                </Predicate>
              </Assert>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>