Skip to content

Instantly share code, notes, and snippets.

/gist:dece76406b436a73a7694dcc4bc21396

Created November 24, 2016 08:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/dece76406b436a73a7694dcc4bc21396 to your computer and use it in GitHub Desktop.
Save anonymous/dece76406b436a73a7694dcc4bc21396 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.0" Build="9.00.3200.00" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementCompId="1" StatementEstRows="155824" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="TimeOut" StatementSubTreeCost="12.0666" StatementText="SELECT * FROM vw_RFQPartVendor" StatementType="SELECT">
<StatementSetOptions ANSI_NULLS="false" ANSI_PADDING="false" ANSI_WARNINGS="false" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="false" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="false" />
<QueryPlan DegreeOfParallelism="1" MemoryGrant="5648" CachedPlanSize="326" CompileTime="232" CompileCPU="208" CompileMemory="2864">
<RelOp AvgRowSize="4642" EstimateCPU="0.0155824" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="155824" LogicalOp="Compute Scalar" NodeId="0" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="12.0666">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1029" />
<ColumnReference Column="Expr1039" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1043" />
<ColumnReference Column="Expr1044" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1039" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[t_user_auth].[userName] IS NULL THEN CONVERT_IMPLICIT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[UserAcc],0) ELSE [Drawingreq].[dbo].[t_user_auth].[userName] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1043" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[t_user_auth].[userName] as [t_user_auth_1].[userName] IS NULL THEN CONVERT_IMPLICIT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[approver],0) ELSE [Drawingreq].[dbo].[t_user_auth].[userName] as [t_user_auth_1].[userName] END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4673" EstimateCPU="1.14814" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="155824" LogicalOp="Right Outer Join" NodeId="1" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="12.051">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1029" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
</OutputList>
<MemoryFractions Input="0.0511364" Output="0.0511364" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="83250" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[Drawingreq].[dbo].[t_user_auth].[user_acc] as [t_user_auth_1].[user_acc]=[Drawingreq].[dbo].[SubconJobQ].[approver]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="1083" EstimateCPU="5.30106E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="53.0106" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0152715">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
<ScalarOperator ScalarString="[Drawingreq].[dbo].[t_user_auth].[userName] as [t_user_auth_1].[userName]">
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4051" EstimateCPU="0.000656936" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="53.0106" LogicalOp="Distinct Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0152662">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</OutputList>
<MemoryFractions Input="1" Output="0.948864" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="4051" EstimateCPU="0.000223" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="60" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.003348">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="60" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="user_acc" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Alias="[t_user_auth_1]" Column="userName" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Index="[PK_t_user_auth]" Alias="[t_user_auth_1]" />
</IndexScan>
</RelOp>
</Sort>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="3615" EstimateCPU="1.10492" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="123674" LogicalOp="Right Outer Join" NodeId="8" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="10.8876">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1029" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
</OutputList>
<MemoryFractions Input="0.0426136" Output="0.0426136" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="83250" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[Drawingreq].[dbo].[t_user_auth].[user_acc]=[Drawingreq].[dbo].[SubconJobQ].[UserAcc]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="1083" EstimateCPU="5.30106E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="53.0106" LogicalOp="Compute Scalar" NodeId="9" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0152715">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
<ScalarOperator ScalarString="[Drawingreq].[dbo].[t_user_auth].[userName]">
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</Identifier>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="4051" EstimateCPU="0.000656936" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="53.0106" LogicalOp="Distinct Sort" NodeId="10" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0152662">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</OutputList>
<MemoryFractions Input="0.948864" Output="0.90625" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="51" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="4051" EstimateCPU="0.000223" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="60" LogicalOp="Clustered Index Scan" NodeId="11" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.003348">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="60" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="user_acc" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Column="userName" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[t_user_auth]" Index="[PK_t_user_auth]" />
</IndexScan>
</RelOp>
</Sort>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="2557" EstimateCPU="1.22461" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="123674" LogicalOp="Right Outer Join" NodeId="15" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="9.76743">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1029" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
</OutputList>
<MemoryFractions Input="0.0905303" Output="0.0905303" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="83250" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Hash>
<DefinedValues />
<HashKeysBuild>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
</HashKeysBuild>
<HashKeysProbe>
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1051" />
</HashKeysProbe>
<ProbeResidual>
<ScalarOperator ScalarString="[Recr1018]=[Drawingreq].[dbo].[t_vendor_email].[vendor] as [outerVendorEmail].[vendor] AND [Expr1051]=[Drawingreq].[dbo].[t_vendor_email].[plant] as [outerVendorEmail].[plant]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1018" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1051" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</ProbeResidual>
<RelOp AvgRowSize="1095" EstimateCPU="0.00191499" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="158.996" LogicalOp="Distinct Sort" NodeId="16" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.101841">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
<ColumnReference Column="Expr1029" />
</OutputList>
<MemoryFractions Input="0.90625" Output="0.81572" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="87" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="true">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</OrderByColumn>
<OrderByColumn Ascending="true">
<ColumnReference Column="Expr1029" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="1103" EstimateCPU="1.59E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="159" LogicalOp="Compute Scalar" NodeId="17" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0886648">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
<ColumnReference Column="Expr1029" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1029" />
<ScalarOperator ScalarString="stuff([Expr1027],(1),(1),N'')">
<Intrinsic FunctionName="stuff">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1027" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N''" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1103" EstimateCPU="0.00066462" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="159" LogicalOp="Inner Join" NodeId="18" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0886489">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
<ColumnReference Column="Expr1027" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="159" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</OuterReferences>
<RelOp AvgRowSize="43" EstimateCPU="0.0003319" EstimateIO="0.00979167" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="159" LogicalOp="Table Scan" NodeId="19" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0101236">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="159" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" />
</TableScan>
</RelOp>
<RelOp AvgRowSize="1067" EstimateCPU="1E-06" EstimateIO="0" EstimateRebinds="157.978" EstimateRewinds="0.0223047" EstimateRows="1" LogicalOp="UDX" NodeId="20" Parallel="false" PhysicalOp="UDX" EstimatedTotalSubtreeCost="0.0778607">
<OutputList>
<ColumnReference Column="Expr1027" />
</OutputList>
<MemoryFractions Input="0" Output="0" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="159" ActualEndOfScans="0" ActualExecutions="159" />
</RunTimeInformation>
<Extension UDXName="FOR XML">
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1027" />
</DefinedValue>
</DefinedValues>
<UsedUDXColumns>
<ColumnReference Column="Expr1026" />
</UsedUDXColumns>
<RelOp AvgRowSize="152" EstimateCPU="1.59E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="158" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="21" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0402859">
<OutputList>
<ColumnReference Column="Expr1026" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1026" />
<ScalarOperator ScalarString="N';'+ltrim(rtrim([Drawingreq].[dbo].[t_vendor_email].[email] as [innerVendorEmail].[email]))">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="ltrim">
<ScalarOperator>
<Intrinsic FunctionName="rtrim">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="email" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="247" EstimateCPU="0.0002534" EstimateIO="0.00987017" EstimateRebinds="0" EstimateRewinds="158" EstimateRows="1" LogicalOp="Table Scan" NodeId="22" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.0377578">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="email" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="222" ActualEndOfScans="159" ActualExecutions="159" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="email" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" />
<Predicate>
<ScalarOperator ScalarString="[Drawingreq].[dbo].[t_vendor_email].[status] as [innerVendorEmail].[status]=(1) AND [Drawingreq].[dbo].[t_vendor_email].[comp_code] as [innerVendorEmail].[comp_code]=[Drawingreq].[dbo].[t_vendor_email].[comp_code] as [outerVendorEmail].[comp_code] AND [Drawingreq].[dbo].[t_vendor_email].[plant] as [innerVendorEmail].[plant]=[Drawingreq].[dbo].[t_vendor_email].[plant] as [outerVendorEmail].[plant] AND [Drawingreq].[dbo].[t_vendor_email].[vendor] as [innerVendorEmail].[vendor]=[Drawingreq].[dbo].[t_vendor_email].[vendor] as [outerVendorEmail].[vendor]">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="comp_code" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="comp_code" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="plant" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="plant" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[innerVendorEmail]" Column="vendor" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[t_vendor_email]" Alias="[outerVendorEmail]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</TableScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Extension>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="1507" EstimateCPU="0.446947" EstimateIO="0.092335" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="96797.8" LogicalOp="Left Outer Join" NodeId="29" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="8.44098">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
<ColumnReference Column="Expr1051" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="83250" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[Drawingreq].[dbo].[SubconJobQ].[Regno]=[Drawingreq].[dbo].[Reg_parts].[Regno]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="1383" EstimateCPU="0.0788545" EstimateIO="0.0384659" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15103" LogicalOp="Right Outer Join" NodeId="30" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="1.78073">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
<ColumnReference Column="Expr1051" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="20137" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Merge ManyToMany="true">
<InnerSideJoinColumns>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</InnerSideJoinColumns>
<OuterSideJoinColumns>
<ColumnReference Column="Recr1017" />
</OuterSideJoinColumns>
<Residual>
<ScalarOperator ScalarString="[Drawingreq].[dbo].[SubconJobQ].[Regno]=[Recr1017]">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1017" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
</Residual>
<RelOp AvgRowSize="1079" EstimateCPU="0.962478" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15103" LogicalOp="Sort" NodeId="31" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="1.06126">
<OutputList>
<ColumnReference Column="Recr1017" />
<ColumnReference Column="Recr1018" />
</OutputList>
<MemoryFractions Input="0.81572" Output="0.488826" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="20137" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Column="Recr1017" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="1079" EstimateCPU="7.5515E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15103" LogicalOp="Lazy Spool" NodeId="32" Parallel="false" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="0.0875199">
<OutputList>
<ColumnReference Column="Expr1067" />
<ColumnReference Column="Recr1017" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Recr1019" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="20137" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Spool Stack="true">
<RelOp AvgRowSize="1079" EstimateCPU="1.5103E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15103" LogicalOp="Concatenation" NodeId="33" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="0.0874428">
<OutputList>
<ColumnReference Column="Expr1067" />
<ColumnReference Column="Recr1017" />
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Recr1019" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="20137" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1067" />
<ColumnReference Column="Expr1064" />
<ColumnReference Column="Expr1066" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Recr1017" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Column="Recr1012" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Recr1018" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1015" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Recr1019" />
<ColumnReference Column="Expr1011" />
<ColumnReference Column="Expr1016" />
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1079" EstimateCPU="0.00015103" EstimateIO="0" EstimateRebinds="15103" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="34" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00015103">
<OutputList>
<ColumnReference Column="Expr1064" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1064" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="2137" EstimateCPU="0.0015102" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15102" LogicalOp="Compute Scalar" NodeId="35" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0621451">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Column="Expr1010" />
<ColumnReference Column="Expr1011" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1010" />
<ScalarOperator ScalarString="substring(CONVERT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[vendor],0),(1),CONVERT_IMPLICIT(int,charindex(N';',CONVERT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[vendor],0)+N';')-(1),0))">
<Intrinsic FunctionName="substring">
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Intrinsic FunctionName="charindex">
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1011" />
<ScalarOperator ScalarString="stuff(CONVERT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[vendor],0),(1),CONVERT_IMPLICIT(int,charindex(N';',CONVERT(nvarchar(max),[Drawingreq].[dbo].[SubconJobQ].[vendor],0)+N';'),0),N'')">
<Intrinsic FunctionName="stuff">
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Intrinsic FunctionName="charindex">
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="false">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N''" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="123" EstimateCPU="0.0167692" EstimateIO="0.0438657" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15102" LogicalOp="Index Scan" NodeId="36" Parallel="false" PhysicalOp="Index Scan" EstimatedTotalSubtreeCost="0.0606349">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="15102" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="vendor" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Index="[ix_RecDate]" TableReferenceId="2" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="1079" EstimateCPU="0.00126865" EstimateIO="0" EstimateRebinds="15103" EstimateRewinds="0" EstimateRows="1.00007" LogicalOp="Assert" NodeId="45" Parallel="false" PhysicalOp="Assert" EstimatedTotalSubtreeCost="0.0252826">
<OutputList>
<ColumnReference Column="Expr1066" />
<ColumnReference Column="Recr1012" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5035" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Assert StartupExpression="false">
<RelOp AvgRowSize="1079" EstimateCPU="0.00126865" EstimateIO="0" EstimateRebinds="15103" EstimateRewinds="0" EstimateRows="1.00007" LogicalOp="Inner Join" NodeId="46" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0252826">
<OutputList>
<ColumnReference Column="Expr1066" />
<ColumnReference Column="Recr1012" />
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5035" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="false">
<OuterReferences>
<ColumnReference Column="Expr1066" />
<ColumnReference Column="Recr1012" />
<ColumnReference Column="Recr1013" />
<ColumnReference Column="Recr1014" />
</OuterReferences>
<RelOp AvgRowSize="1079" EstimateCPU="0.00015103" EstimateIO="0" EstimateRebinds="15103" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="47" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00015103">
<OutputList>
<ColumnReference Column="Expr1066" />
<ColumnReference Column="Recr1012" />
<ColumnReference Column="Recr1013" />
<ColumnReference Column="Recr1014" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1066" />
<ScalarOperator ScalarString="[Expr1065]+(1)">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1065" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="1079" EstimateCPU="0.00015103" EstimateIO="0" EstimateRebinds="15103" EstimateRewinds="0" EstimateRows="1" LogicalOp="Lazy Spool" NodeId="48" Parallel="false" PhysicalOp="Table Spool" EstimatedTotalSubtreeCost="0.00015103">
<OutputList>
<ColumnReference Column="Expr1065" />
<ColumnReference Column="Recr1012" />
<ColumnReference Column="Recr1013" />
<ColumnReference Column="Recr1014" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="20137" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Spool Stack="true" PrimaryNodeId="32" />
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp AvgRowSize="2125" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="15102" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="52" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0238629">
<OutputList>
<ColumnReference Column="Expr1015" />
<ColumnReference Column="Expr1016" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1015" />
<ScalarOperator ScalarString="substring([Recr1014],(1),CONVERT_IMPLICIT(int,charindex(N';',[Recr1014]+N';')-(1),0))">
<Intrinsic FunctionName="substring">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1014" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Intrinsic FunctionName="charindex">
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1014" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1016" />
<ScalarOperator ScalarString="stuff([Recr1014],(1),CONVERT_IMPLICIT(int,charindex(N';',[Recr1014]+N';'),0),N'')">
<Intrinsic FunctionName="stuff">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1014" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="true">
<ScalarOperator>
<Intrinsic FunctionName="charindex">
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1014" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N';'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N''" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="9" EstimateCPU="4.8E-07" EstimateIO="0" EstimateRebinds="15102" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="53" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="0.0223526">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="7585" ActualRewinds="12552" ActualRows="5035" ActualEndOfScans="20137" ActualExecutions="20137" />
</RunTimeInformation>
<Filter StartupExpression="true">
<RelOp AvgRowSize="9" EstimateCPU="1.157E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="15102" EstimateRows="1" LogicalOp="Constant Scan" NodeId="54" Parallel="false" PhysicalOp="Constant Scan" EstimatedTotalSubtreeCost="0.0151032">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5035" ActualEndOfScans="5035" ActualExecutions="5035" />
</RunTimeInformation>
<ConstantScan />
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[Recr1014]&gt;N''">
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Recr1014" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N''" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</ComputeScalar>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="CASE WHEN [Expr1066]&gt;(100) THEN (0) ELSE NULL END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="GT">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1066" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(100)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Predicate>
</Assert>
</RelOp>
</Concat>
</RelOp>
</Spool>
</RelOp>
</Sort>
</RelOp>
<RelOp AvgRowSize="325" EstimateCPU="0.0015102" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15102" LogicalOp="Compute Scalar" NodeId="62" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.602145">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
<ColumnReference Column="Expr1040" />
<ColumnReference Column="Expr1041" />
<ColumnReference Column="Expr1042" />
<ColumnReference Column="Expr1044" />
<ColumnReference Column="Expr1051" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1040" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[IsPara]='1' THEN 'yes' ELSE 'no' END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPara" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'1'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'yes'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="'no'" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1041" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[IsDxf]='1' THEN 'yes' ELSE 'no' END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsDxf" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'1'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'yes'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="'no'" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1042" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[IsPdf]='1' THEN 'yes' ELSE 'no' END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPdf" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'1'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'yes'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="'no'" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1044" />
<ScalarOperator ScalarString="CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[req_type]='sq' THEN 'SubContracting Part' ELSE CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[req_type]='sd' THEN 'Resend Drawing' ELSE CASE WHEN [Drawingreq].[dbo].[SubconJobQ].[req_type]='pq' THEN 'New Part' ELSE '' END END END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="req_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sq'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'SubContracting Part'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="req_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sd'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'Resend Drawing'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="req_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'pq'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="'New Part'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="''" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1051" />
<ScalarOperator ScalarString="CONVERT_IMPLICIT(nchar(4),[Drawingreq].[dbo].[SubconJobQ].[plant],0)">
<Convert DataType="nchar" Length="8" Style="0" Implicit="true">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp AvgRowSize="302" EstimateCPU="0.0167692" EstimateIO="0.583866" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="15102" LogicalOp="Clustered Index Scan" NodeId="63" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.600635">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPara" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsDxf" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPdf" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="req_type" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="15102" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Regno" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="UserAcc" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPara" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsDxf" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="IsPdf" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Rec_date" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Cov_date" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Status" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Remark" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="plant" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="doc_support" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="approver" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="Comment" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="sync_status" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="ModuleNo" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="req_type" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Column="projectNo" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[SubconJobQ]" Index="[PK_SubconJobQ]" TableReferenceId="1" />
</IndexScan>
</RelOp>
</ComputeScalar>
</RelOp>
</Merge>
</RelOp>
<RelOp AvgRowSize="143" EstimateCPU="4.51109" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="61755" LogicalOp="Sort" NodeId="76" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="6.12097">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
</OutputList>
<MemoryFractions Input="0.326894" Output="0.326894" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="61755" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="false">
<OrderBy>
<OrderByColumn Ascending="true">
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
</OrderByColumn>
</OrderBy>
<RelOp AvgRowSize="143" EstimateCPU="0.0680875" EstimateIO="1.53053" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="61755" LogicalOp="Table Scan" NodeId="77" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="1.59862">
<OutputList>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="61755" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<TableScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Regno" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Partno" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Quantity" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" Column="Part_desc" />
</DefinedValue>
</DefinedValues>
<Object Database="[Drawingreq]" Schema="[dbo]" Table="[Reg_parts]" />
</TableScan>
</RelOp>
</Sort>
</RelOp>
</Merge>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</Hash>
</RelOp>
</ComputeScalar>
</RelOp>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment