I'm not sure how else to post it, so here is the plan in XML format.
<?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.1" Build="10.0.5512.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="39232.5" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="130.18" StatementText="SELECT TOP (100) PERCENT ul.UnitNumber ,ul.fldDateTime ,CASE WHEN derivedtbl_2.SectionNumber IS NULL THEN CASE WHEN Departments.SectionNumber IS NULL THEN '9999' ELSE Departments.SectionNumber END ELSE derivedtbl_2.SectionNumber END AS SectionNumber ,dbo.AlphaUnits.UnitStatus AS AlphaStatus ,CASE WHEN dbo.ActiveSafetyTimers.TimerExpr IS NULL THEN NULL ELSE TimerExpr END AS TimerExpr ,ul.RCN ,ul.UnitStatus ,CASE WHEN CCNo = '' THEN NULL ELSE CCNo END AS CCNo ,CASE WHEN Unit2 IS NULL THEN NULL ELSE '*' END AS IsJoined ,ul.CommCenter AS CurrentCommCenter ,CASE WHEN derivedtbl_2.CommCenter IS NULL THEN departments.CommCenter ELSE derivedtbl_2.CommCenter END AS PrimaryCommCenter FROM ( SELECT ul2.*, ROW_NUMBER() OVER(PARTITION BY ul2.UnitNumber ORDER BY fldDateTime DESC) AS row_num FROM dbo.UnitLog ul2 WHERE (ul2.UnitStatus <> 'LOG') AND (ul2.fldDateTime <= DATEADD(SECOND, 15, GETDATE())) ) AS ul LEFT JOIN dbo.Departments ON ul.UnitNumber = dbo.Departments.CallSign LEFT JOIN ( SELECT TOP (100) PERCENT [#temp_qryPersonnel].DepartmentID ,[#temp_qryPersonnel].UnitID ,Departments_1.SectionNumber ,Departments_1.CommCenter FROM dbo.DepartmentPersonnel AS [#temp_qryPersonnel] LEFT JOIN dbo.Departments AS Departments_1 ON [#temp_qryPersonnel].DepartmentID = Departments_1.RCN WHERE ([#temp_qryPersonnel].Active = 1) AND ([#temp_qryPersonnel].UnitID IS NOT NULL) --ORDER BY [#temp_qryPersonnel].UnitID ) AS derivedtbl_2 ON ul.UnitNumber = derivedtbl_2.UnitID LEFT JOIN dbo.AlphaUnits ON ul.UnitNumber = dbo.AlphaUnits.UnitNumber LEFT JOIN dbo.JoinedUnits ON ul.UnitNumber = dbo.JoinedUnits.Unit1 LEFT JOIN dbo.ActiveSafetyTimers ON ul.UnitNumber = dbo.ActiveSafetyTimers.UnitNumber WHERE ul.row_num = 1 AND ul.UnitStatus NOT LIKE '10-42%'" StatementType="SELECT" QueryHash="0xD6474B54A498D18C" QueryPlanHash="0x447C1CC7E068385D">
<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="4" MemoryGrant="167584" CachedPlanSize="160" CompileTime="102" CompileCPU="102" CompileMemory="1744">
<RelOp AvgRowSize="62" EstimateCPU="0.00392325" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="130.18">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Column="Expr1022" />
<ColumnReference Column="Expr1023" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1025" />
<ColumnReference Column="Expr1026" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1022" />
<ScalarOperator ScalarString="CASE WHEN [Expr1011] IS NULL THEN CASE WHEN [CADRecords].[dbo].[Departments].[SectionNumber] IS NULL THEN '9999' ELSE [CADRecords].[dbo].[Departments].[SectionNumber] END ELSE [Expr1011] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'9999'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1011" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1023" />
<ScalarOperator ScalarString="CASE WHEN [CADRecords].[dbo].[ActiveSafetyTimers].[TimerExpr] IS NULL THEN NULL ELSE [CADRecords].[dbo].[ActiveSafetyTimers].[TimerExpr] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1026" />
<ScalarOperator ScalarString="CASE WHEN [Expr1012] IS NULL THEN [CADRecords].[dbo].[Departments].[CommCenter] ELSE [Expr1012] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1012" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="68" EstimateCPU="0.0293824" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Gather Streams" NodeId="1" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="130.176">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1025" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="43" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Parallelism>
<RelOp AvgRowSize="68" EstimateCPU="0.194781" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Right Outer Join" NodeId="2" Parallel="true" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="130.147">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1025" />
</OutputList>
<MemoryFractions Input="0" Output="0" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="UnitNumber" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[UnitNumber] as [ul2].[UnitNumber]=[CADRecords].[dbo].[ActiveSafetyTimers].[UnitNumber]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="22" EstimateCPU="0.0285498" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="16" LogicalOp="Distribute Streams" NodeId="3" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0318494">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Broadcast">
<RelOp AvgRowSize="22" EstimateCPU="0.0001746" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="16" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032996" TableCardinality="16">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="16" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="UnitNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Column="TimerExpr" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[ActiveSafetyTimers]" Index="[PK__ActiveSa__D3CC338A39CD8610]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="60" EstimateCPU="0.00196162" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Compute Scalar" NodeId="5" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="129.92">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Column="Expr1024" />
<ColumnReference Column="Expr1025" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1025" />
<ScalarOperator ScalarString="CASE WHEN [CADRecords].[dbo].[JoinedUnits].[Unit2] IS NULL THEN NULL ELSE '*' END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="'*'" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="64" EstimateCPU="0.0477918" EstimateIO="0.0004695" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Left Outer Join" NodeId="6" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="129.918">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit2" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[UnitNumber] as [ul2].[UnitNumber]=[CADRecords].[dbo].[JoinedUnits].[Unit1]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="58" EstimateCPU="0.0496031" EstimateIO="0.0001565" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Left Outer Join" NodeId="7" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="129.838">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[UnitNumber] as [ul2].[UnitNumber]=[CADRecords].[dbo].[AlphaUnits].[UnitNumber]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="57" EstimateCPU="0.053908" EstimateIO="0.0379382" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Left Outer Join" NodeId="8" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="129.757">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[UnitNumber] as [ul2].[UnitNumber]=[CADRecords].[dbo].[DepartmentPersonnel].[UnitID] as [#temp_qryPersonnel].[UnitID]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="50" EstimateCPU="0.0557269" EstimateIO="0.000313" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Right Outer Join" NodeId="9" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="129.534">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[UnitNumber] as [ul2].[UnitNumber]=[CADRecords].[dbo].[Departments].[CallSign]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="21" EstimateCPU="0.000788558" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134" LogicalOp="Sort" NodeId="10" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0411271">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</OutputList>
<MemoryFractions Input="0.000204719" Output="0.000204719" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="21" EstimateCPU="0.0290563" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134" LogicalOp="Distribute Streams" NodeId="11" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0347079">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="131" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</PartitionColumns>
<RelOp AvgRowSize="21" EstimateCPU="0.0003044" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134" LogicalOp="Clustered Index Scan" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00565162" TableCardinality="134">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="134" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="SectionNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CommCenter" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Column="CallSign" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Index="[PK__Departme__CAFF900C47A6A41B]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="44" EstimateCPU="0.365649" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Repartition Streams" NodeId="13" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="129.437">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="12" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</PartitionColumns>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="44" EstimateCPU="1.03172" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="39232.5" LogicalOp="Filter" NodeId="14" Parallel="true" PhysicalOp="Filter" EstimatedTotalSubtreeCost="129.071">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Expr1024" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="10" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="7" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="15" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="11" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="false">
<RelOp AvgRowSize="52" EstimateCPU="0.074762" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Compute Scalar" NodeId="15" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="128.04">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1024" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1024" />
<ScalarOperator ScalarString="CASE WHEN [CADRecords].[dbo].[UnitLog].[CCNo] as [ul2].[CCNo]='' THEN NULL ELSE [CADRecords].[dbo].[UnitLog].[CCNo] as [ul2].[CCNo] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="''" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="52" EstimateCPU="11.3931" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Distribute Streams" NodeId="16" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="127.965">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Expr1002" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="373810" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="373810" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="373810" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="373810" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="RoundRobin">
<RelOp AvgRowSize="52" EstimateCPU="0.119619" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Compute Scalar" NodeId="17" Parallel="false" PhysicalOp="Sequence Project" EstimatedTotalSubtreeCost="116.572">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Expr1002" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1495240" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<SequenceProject>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="row_number">
<Sequence FunctionName="row_number" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="52" EstimateCPU="0.0299048" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Segment" NodeId="18" Parallel="false" PhysicalOp="Segment" EstimatedTotalSubtreeCost="116.452">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
<ColumnReference Column="Segment1034" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1495240" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Segment>
<GroupBy>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</GroupBy>
<SegmentColumn>
<ColumnReference Column="Segment1034" />
</SegmentColumn>
<RelOp AvgRowSize="44" EstimateCPU="12.4132" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Gather Streams" NodeId="19" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="116.422">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="1495240" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism>
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OrderByColumn>
<OrderByColumn Ascending="false">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="44" EstimateCPU="23.6191" EstimateIO="73.2151" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Sort" NodeId="20" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="104.009">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
</OutputList>
<MemoryFractions Input="0.998567" Output="0.998567" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="393266" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="350378" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="373879" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="377717" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</OrderByColumn>
<OrderByColumn Ascending="false">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="44" EstimateCPU="0.835735" EstimateIO="5.67053" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1495240" LogicalOp="Index Scan" NodeId="21" Parallel="true" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="6.50627" TableCardinality="1519380">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="393266" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="350378" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="373879" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="377717" 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="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="RCN" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CCNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="CommCenter" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Index="[SuggestedByUnitClient2]" Alias="[ul2]" IndexKind="NonClustered" />
<Predicate>
<ScalarOperator ScalarString="[CADRecords].[dbo].[UnitLog].[fldDateTime] as [ul2].[fldDateTime]<=CONVERT_IMPLICIT(datetime2(7),dateadd(second,(15),getdate()),0) AND [CADRecords].[dbo].[UnitLog].[UnitStatus] as [ul2].[UnitStatus]<>'LOG'">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="LE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="fldDateTime" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1027">
<ScalarOperator>
<Convert DataType="datetime2" Style="0" Implicit="true">
<ScalarOperator>
<Intrinsic FunctionName="dateadd">
<ScalarOperator>
<Const ConstValue="(8)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(15)" />
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="getdate" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'LOG'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Sort>
</RelOp>
</Parallelism>
</RelOp>
</Segment>
</RelOp>
</SequenceProject>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="NOT [CADRecords].[dbo].[UnitLog].[UnitStatus] as [ul2].[UnitStatus] like '10-42%' AND [Expr1002]=(1)">
<Logical Operation="AND">
<ScalarOperator>
<Logical Operation="NOT">
<ScalarOperator>
<Intrinsic FunctionName="like">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[UnitLog]" Alias="[ul2]" Column="UnitStatus" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'10-42%'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Logical>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1002" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</Parallelism>
</RelOp>
</Merge>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.00514215" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Sort" NodeId="30" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.130618">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OutputList>
<MemoryFractions Input="0.000614156" Output="0.000614156" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="175" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="162" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="166" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="168" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="20" EstimateCPU="3.45983E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Compute Scalar" NodeId="31" Parallel="true" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.119845">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1012" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ScalarOperator ScalarString="[CADRecords].[dbo].[Departments].[SectionNumber] as [Departments_1].[SectionNumber]">
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1012" />
<ScalarOperator ScalarString="[CADRecords].[dbo].[Departments].[CommCenter] as [Departments_1].[CommCenter]">
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="20" EstimateCPU="0.0289631" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Repartition Streams" NodeId="32" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.11981">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="175" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="169" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="171" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</PartitionColumns>
<RelOp AvgRowSize="20" EstimateCPU="0.00370186" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Right Outer Join" NodeId="33" Parallel="true" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.0908472">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="159" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="205" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Merge ManyToMany="false">
<InnerSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[CADRecords].[dbo].[DepartmentPersonnel].[DepartmentID] as [#temp_qryPersonnel].[DepartmentID]=[CADRecords].[dbo].[Departments].[RCN] as [Departments_1].[RCN]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="17" EstimateCPU="0.029006" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134" LogicalOp="Distribute Streams" NodeId="34" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0346576">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="32" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="35" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="29" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="31" ActualEndOfScans="0" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
</PartitionColumns>
<RelOp AvgRowSize="17" EstimateCPU="0.0003044" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="134" LogicalOp="Clustered Index Scan" NodeId="35" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00565162" TableCardinality="134">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="134" 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="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="RCN" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="SectionNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Alias="[Departments_1]" Column="CommCenter" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[Departments]" Index="[PK__Departme__CAFF900C47A6A41B]" Alias="[Departments_1]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
<RelOp AvgRowSize="18" EstimateCPU="0.00514215" EstimateIO="0.00563063" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Sort" NodeId="36" Parallel="true" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0524847">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</OutputList>
<MemoryFractions Input="0.000614156" Output="0.000614156" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRebinds="1" ActualRewinds="0" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRebinds="1" ActualRewinds="0" ActualRows="159" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRebinds="1" ActualRewinds="0" ActualRows="205" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRebinds="1" ActualRewinds="0" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRebinds="0" ActualRewinds="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="18" EstimateCPU="0.0296633" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Repartition Streams" NodeId="37" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0417119">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="151" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="159" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="205" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="177" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
</PartitionColumns>
<RelOp AvgRowSize="19" EstimateCPU="0.0004657" EstimateIO="0.0112731" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="691.966" LogicalOp="Clustered Index Scan" NodeId="38" Parallel="true" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0117388" TableCardinality="704">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="3" ActualRows="179" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="4" ActualRows="182" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="169" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="162" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="DepartmentID" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Index="[PK_DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" IndexKind="Clustered" />
<Predicate>
<ScalarOperator ScalarString="[CADRecords].[dbo].[DepartmentPersonnel].[Active] as [#temp_qryPersonnel].[Active]=(1) AND [CADRecords].[dbo].[DepartmentPersonnel].[UnitID] as [#temp_qryPersonnel].[UnitID] IS NOT NULL">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="Active" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[DepartmentPersonnel]" Alias="[#temp_qryPersonnel]" Column="UnitID" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
<RelOp AvgRowSize="15" EstimateCPU="0.0285065" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Distribute Streams" NodeId="46" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317907">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="2" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
</PartitionColumns>
<RelOp AvgRowSize="15" EstimateCPU="0.0001592" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="2" LogicalOp="Clustered Index Scan" NodeId="47" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="2" 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="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitNumber" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Column="UnitStatus" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[AlphaUnits]" Index="[PK__AlphaUni__44F5EC95286302EC]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Merge>
</RelOp>
<RelOp AvgRowSize="20" EstimateCPU="0.0285108" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3" LogicalOp="Distribute Streams" NodeId="49" Parallel="true" PhysicalOp="Parallelism" EstimatedTotalSubtreeCost="0.0317961">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="4" ActualRows="3" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="3" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="1" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="2" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Parallelism PartitioningType="Hash">
<PartitionColumns>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
</PartitionColumns>
<RelOp AvgRowSize="20" EstimateCPU="0.0001603" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="3" LogicalOp="Clustered Index Scan" NodeId="50" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3">
<OutputList>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit2" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="1" ActualRows="3" 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="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit1" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Column="Unit2" />
</DefinedValue>
</DefinedValues>
<Object Database="[CADRecords]" Schema="[dbo]" Table="[JoinedUnits]" Index="[PK_JoinedUnits]" IndexKind="Clustered" />
</IndexScan>
</RelOp>
</Parallelism>
</RelOp>
</Merge>
</RelOp>
</ComputeScalar>
</RelOp>
</Hash>
</RelOp>
</Parallelism>
</RelOp>
</ComputeScalar>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>