GOOD QUERY XML:

<?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.1" Build="10.50.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

<StmtSimple StatementCompId="1" StatementEstRows="2.36611" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="21.8508" StatementText="select 'A' as tab , 0 as tag , t . subscription_id , t . article , t . control , t . frequency , t . start_day , t . participant_id , t . legacy_part_id , t . description , t . quantity , t . zone , t . pickup_flag , t . date_from , t . date_to , t . wear_select_dt , t . manually_closed , t . apar_id , t . apar_name , t . ext_apar_ref , t . parent_cas_id , t . art_descr , t . agree_item_id , t . report_flag , t . customer_key , t . dose_category , t . dosimeter_use , t . cust , t . sequence_no , t . level , t . product_line , t . al_create_date , t . al_date_to from aq1viagreeitem t where @0 = @1 and t . parent_cas_id = @2 order by 1" StatementType="SELECT" QueryHash="0xFBA5C36153A5C81E" QueryPlanHash="0x49F26EB3BE4CD1BD">

<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="2" MemoryGrant="9376" CachedPlanSize="344" CompileTime="3524" CompileCPU="575" CompileMemory="12504">

<RelOp AvgRowSize="388" EstimateCPU="2.36611E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="21.8508">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

<ColumnReference Column="Expr1023" />

<ColumnReference Column="Expr1027" />

<ColumnReference Column="Expr1028" />

</OutputList>

<ComputeScalar>

<DefinedValues>

<DefinedValue>

<ColumnReference Column="Expr1023" />

<ScalarOperator ScalarString="CASE WHEN [Expr1032]=(1) THEN [TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(2) THEN [TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id] ELSE CASE WHEN CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)=(3) THEN [TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh2].[parent_cas_id] ELSE NULL END END END">

<IF>

<Condition>

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Column="Expr1032" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="(1)" />

</ScalarOperator>

</Compare>

</ScalarOperator>

</Condition>

<Then>

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

</Identifier>

</ScalarOperator>

</Then>

<Else>

<ScalarOperator>

<IF>

<Condition>

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Convert DataType="int" Style="0" Implicit="true">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

</Identifier>

</ScalarOperator>

</Convert>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="(2)" />

</ScalarOperator>

</Compare>

</ScalarOperator>

</Condition>

<Then>

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

</Identifier>

</ScalarOperator>

</Then>

<Else>

<ScalarOperator>

<IF>

<Condition>

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Convert DataType="int" Style="0" Implicit="true">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

</Identifier>

</ScalarOperator>

</Convert>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="(3)" />

</ScalarOperator>

</Compare>

</ScalarOperator>

</Condition>

<Then>

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

</Identifier>

</ScalarOperator>

</Then>

<Else>

<ScalarOperator>

<Const ConstValue="NULL" />

</ScalarOperator>

</Else>

</IF>

</ScalarOperator>

</Else>

</IF>

</ScalarOperator>

</Else>

</IF>

</ScalarOperator>

</DefinedValue>

<DefinedValue>

<ColumnReference Column="Expr1027" />

<ScalarOperator ScalarString="'A'">

<Const ConstValue="'A'" />

</ScalarOperator>

</DefinedValue>

<DefinedValue>

<ColumnReference Column="Expr1028" />

<ScalarOperator ScalarString="(0)">

<Const ConstValue="(0)" />

</ScalarOperator>

</DefinedValue>

</DefinedValues>

<RelOp AvgRowSize="397" EstimateCPU="0.0285532" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="21.8508">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="0" ActualRows="3459" ActualEndOfScans="1" ActualExecutions="1" />

</RunTimeInformation>

<Parallelism>

<RelOp AvgRowSize="397" EstimateCPU="4.94517E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Left Outer Join" NodeId="2" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.8223">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OuterReferences>

<RelOp AvgRowSize="393" EstimateCPU="4.94517E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Inner Join" NodeId="3" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.8165">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</OuterReferences>

<RelOp AvgRowSize="387" EstimateCPU="0.0218003" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2.36611" LogicalOp="Inner Join" NodeId="4" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="21.813">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<MemoryFractions Input="0" Output="0" />

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<Hash>

<DefinedValues />

<HashKeysBuild>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

</HashKeysBuild>

<HashKeysProbe>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

</HashKeysProbe>

<ProbeResidual>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[client] as [r].[client]=[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client] AND [TESTSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value]=[TESTSERVER].[dbo].[auiinvdetail].[article] as [al].[article]">

<Logical Operation="AND">

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

</Compare>

</ScalarOperator>

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

</Identifier>

</ScalarOperator>

</Compare>

</ScalarOperator>

</Logical>

</ScalarOperator>

</ProbeResidual>

<RelOp AvgRowSize="26" EstimateCPU="0.0285039" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Distribute Streams" NodeId="6" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.031787">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1544" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1544" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<Parallelism PartitioningType="Broadcast">

<RelOp AvgRowSize="26" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="7" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="5229330">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1544" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="client" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_value" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[IX_AGLRELVALUE_RELATTRID_ATTRIBUTEID_ATTVALUE_RELVALUE]" Alias="[r]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="rel_attr_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="attribute_id" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="'Q50'">

<Const ConstValue="'Q50'" />

</ScalarOperator>

<ScalarOperator ScalarString="'D0'">

<Const ConstValue="'D0'" />

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</Parallelism>

</RelOp>

<RelOp AvgRowSize="374" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="8" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="21.7594">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="true" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

<ColumnReference Column="Expr1042" />

</OuterReferences>

<RelOp AvgRowSize="228" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="11" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="17.7559">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="true" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Column="Expr1041" />

</OuterReferences>

<RelOp AvgRowSize="216" EstimateCPU="0.00257587" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="14" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="13.9214">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Column="Expr1040" />

</OuterReferences>

<RelOp AvgRowSize="201" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="16" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="10.104">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="true" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Column="Expr1039" />

</OuterReferences>

<RelOp AvgRowSize="168" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="19" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="6.06486">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="true" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

<ColumnReference Column="Expr1038" />

</OuterReferences>

<RelOp AvgRowSize="91" EstimateCPU="0.00257586" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1232.47" LogicalOp="Inner Join" NodeId="22" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="2.04446">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="true" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Column="Expr1037" />

</OuterReferences>

<RelOp AvgRowSize="71" EstimateCPU="2.26447E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Compute Scalar" NodeId="25" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="1.89477">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

<ColumnReference Column="Expr1032" />

</OutputList>

<ComputeScalar>

<DefinedValues>

<DefinedValue>

<ColumnReference Column="Expr1032" />

<ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[TESTSERVER].[dbo].[aq1extacuheader].[org_level] as [xh].[org_level],0)">

<Convert DataType="int" Style="0" Implicit="true">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

</Identifier>

</ScalarOperator>

</Convert>

</ScalarOperator>

</DefinedValue>

</DefinedValues>

<RelOp AvgRowSize="67" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="26" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.89476">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

<ColumnReference Column="Expr1036" />

</OuterReferences>

<RelOp AvgRowSize="49" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="28" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.75098">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

<ColumnReference Column="Expr1035" />

</OuterReferences>

<RelOp AvgRowSize="30" EstimateCPU="9.46547E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Inner Join" NodeId="30" Parallel="true" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="1.60545">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<NestedLoops Optimized="false" WithUnorderedPrefetch="true">

<OuterReferences>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />

<ColumnReference Column="Expr1034" />

</OuterReferences>

<RelOp AvgRowSize="30" EstimateCPU="0.0286049" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Repartition Streams" NodeId="32" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="1.49024">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<Parallelism PartitioningType="RoundRobin">

<RelOp AvgRowSize="30" EstimateCPU="0.224347" EstimateIO="1.13942" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="45.2893" LogicalOp="Index Scan" NodeId="33" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="1.36377" TableCardinality="407760">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="2" ActualRows="236" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="1" ActualRows="6" ActualEndOfScans="1" ActualExecutions="1" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="false" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="org_level" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_EXTACUHEADER_ORGLEVEL_INCL_APAR_CLIENT_PARENTCAS]" Alias="[xc]" IndexKind="NonClustered" />

<Predicate>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xc].[parent_cas_id]=[@2]">

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="parent_cas_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Column="@2" />

</Identifier>

</ScalarOperator>

</Compare>

</ScalarOperator>

</Predicate>

</IndexScan>

</RelOp>

</Parallelism>

</RelOp>

<RelOp AvgRowSize="21" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="34" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.143729" TableCardinality="407733">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[IX_ACUHEADER_APARID_CLIENT_STATUS_APARGRID]" Alias="[cas]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="status" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xc].[apar_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="apar_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xc].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xc]" Column="client" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="'N'">

<Const ConstValue="'N'" />

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="32" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="35" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.145429" TableCardinality="407733">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_name" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="ext_apar_ref" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Index="[PK_acuheader]" Alias="[c]" IndexKind="Clustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[c]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="30" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="36" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.143692" TableCardinality="407760">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="2" ActualRows="121" ActualEndOfScans="0" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="org_level" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[apar_id] as [cas].[apar_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="apar_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[acuheader].[client] as [cas].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[acuheader]" Alias="[cas]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

</ComputeScalar>

</RelOp>

<RelOp AvgRowSize="37" EstimateCPU="7.61972E-06" EstimateIO="0" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="27.2133" LogicalOp="Filter" NodeId="40" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.147116">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRebinds="121" ActualRewinds="0" ActualRows="1592" ActualEndOfScans="121" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="2" ActualRebinds="121" ActualRewinds="0" ActualRows="1867" ActualEndOfScans="121" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<Filter StartupExpression="true">

<RelOp AvgRowSize="37" EstimateCPU="0.000186935" EstimateIO="0.003125" EstimateRebinds="44.2893" EstimateRewinds="0" EstimateRows="27.2133" LogicalOp="Index Seek" NodeId="41" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.146771" TableCardinality="4246870">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="121" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="121" ActualExecutions="121" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[IX_AQ1AGREEITEM_APARID_CLIENT]" Alias="[ai]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[apar_id] as [xh].[apar_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="apar_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

<Predicate>

<ScalarOperator ScalarString="[@0]=[@1]">

<Identifier>

<ColumnReference Column="ConstExpr1029">

<ScalarOperator>

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Column="@0" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Identifier>

<ColumnReference Column="@1" />

</Identifier>

</ScalarOperator>

</Compare>

</ScalarOperator>

</ColumnReference>

</Identifier>

</ScalarOperator>

</Predicate>

</Filter>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="90" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="44" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.01783" TableCardinality="4246870">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="customer_key" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_from" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="date_to" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="manually_closed" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="pickup_flag" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="quantity" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="report_flag" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="wear_select_dt" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="zone" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Index="[aiaq1agreeitem0]" Alias="[ai]" TableReferenceId="-1" IndexKind="Clustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[client] as [ai].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="client" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[agree_item_id] as [ai].[agree_item_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="agree_item_id" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="68" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.03658" TableCardinality="7782800">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="description" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="dosimeter_use" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="legacy_part_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Index="[PK_aq1participant]" Alias="[p]" IndexKind="Clustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="participant_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1participant]" Alias="[p]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[participant_id] as [ai].[participant_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="participant_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="22" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="69" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.81485" TableCardinality="1148620">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="control" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="start_day" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Index="[IX_AQ1EXTUIDETAIL_SUBSCRIPTID_SEQNO_CLIENT_NEXTWEARBEGIN_PICKUPFLAG_INCL]" Alias="[xal]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[subscription_id] as [ai].[subscription_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="subscription_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1agreeitem].[sequence_no] as [ai].[sequence_no]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1agreeitem]" Alias="[ai]" Column="sequence_no" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="31" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="70" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="3.83186" TableCardinality="1148620">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1592" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1867" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="create_date" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="date_to" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[IX_AUIINVDETAIL_CLIENT_SUBID_SEQ_AGRTID_CREATEDT_DATETO_APARID]" Alias="[al]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="subscription_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="sequence_no" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extuidetail].[subscription_id] as [xal].[subscription_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="subscription_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extuidetail].[sequence_no] as [xal].[sequence_no]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extuidetail]" Alias="[xal]" Column="sequence_no" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="166" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1231.47" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="72" Parallel="true" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="4.00098" TableCardinality="1148620">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="art_descr" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="article" />

</DefinedValue>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="frequency" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Index="[PK_auiinvdetail ]" Alias="[al]" TableReferenceId="-1" IndexKind="Clustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[auiinvdetail].[agrtid] as [al].[agrtid]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[auiinvdetail]" Alias="[al]" Column="agrtid" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

</Hash>

</RelOp>

<RelOp AvgRowSize="27" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="1.36611" EstimateRows="1" LogicalOp="Index Seek" NodeId="81" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00349908" TableCardinality="5229330">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="1592" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="1867" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_value" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Index="[aiaglrelvalue3]" Alias="[r2]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="client" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="att_value" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="rel_attr_id" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[att_value] as [r].[att_value]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r]" Column="att_value" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="'JL85'">

<Const ConstValue="'JL85'" />

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

<Predicate>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aglrelvalue].[attribute_id] as [r2].[attribute_id]='D0'">

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aglrelvalue]" Alias="[r2]" Column="attribute_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="'D0'" />

</ScalarOperator>

</Compare>

</ScalarOperator>

</Predicate>

</IndexScan>

</RelOp>

</NestedLoops>

</RelOp>

<RelOp AvgRowSize="17" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="1.36611" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="82" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.00575227">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="1591" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="1866" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<Filter StartupExpression="true">

<RelOp AvgRowSize="17" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="1.36611" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="83" Parallel="true" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00575113" TableCardinality="407760">

<OutputList>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

</OutputList>

<RunTimeInformation>

<RunTimeCountersPerThread Thread="1" ActualRows="1592" ActualEndOfScans="0" ActualExecutions="1592" />

<RunTimeCountersPerThread Thread="2" ActualRows="1867" ActualEndOfScans="0" ActualExecutions="1867" />

<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />

</RunTimeInformation>

<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">

<DefinedValues>

<DefinedValue>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="parent_cas_id" />

</DefinedValue>

</DefinedValues>

<Object Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Index="[IX_aq1extacuheader_aparid_client_parentcasid_orglevel]" Alias="[xh2]" IndexKind="NonClustered" />

<SeekPredicates>

<SeekPredicateNew>

<SeekKeys>

<Prefix ScanType="EQ">

<RangeColumns>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="apar_id" />

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh2]" Column="client" />

</RangeColumns>

<RangeExpressions>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[parent_cas_id] as [xh].[parent_cas_id]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="parent_cas_id" />

</Identifier>

</ScalarOperator>

<ScalarOperator ScalarString="[TESTSERVER].[dbo].[aq1extacuheader].[client] as [xh].[client]">

<Identifier>

<ColumnReference Database="[TESTSERVER]" Schema="[dbo]" Table="[aq1extacuheader]" Alias="[xh]" Column="client" />

</Identifier>

</ScalarOperator>

</RangeExpressions>

</Prefix>

</SeekKeys>

</SeekPredicateNew>

</SeekPredicates>

</IndexScan>

</RelOp>

<Predicate>

<ScalarOperator ScalarString="[Expr1032]=(3)">

<Compare CompareOp="EQ">

<ScalarOperator>

<Identifier>

<ColumnReference Column="Expr1032" />

</Identifier>

</ScalarOperator>

<ScalarOperator>

<Const ConstValue="(3)" />

</ScalarOperator>

</Compare>

</ScalarOperator>

</Predicate>

</Filter>

</RelOp>

</NestedLoops>

</RelOp>

</Parallelism>

</RelOp>

</ComputeScalar>

</RelOp>

<ParameterList>

<ColumnReference Column="@2" ParameterCompiledValue="'10922'" ParameterRuntimeValue="'10922'" />

<ColumnReference Column="@1" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />

<ColumnReference Column="@0" ParameterCompiledValue="(1)" ParameterRuntimeValue="(1)" />

</ParameterList>

</QueryPlan>

</StmtSimple>

</Statements>

</Batch>

</BatchSequence>

</ShowPlanXML>