<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3030.27"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT A.Name,A.budget_day,B.MonthName,B.totaldays*A.budget_day as MonthlySpent
FROM 
[dbo].[EmployeeMonthlyBudget] A
inner join(
SELECT [Name] , DATENAME(MONTH, DATEADD(MONTH, nos.monthnos, [DateCreated])-1) AS MonthName,DAY(EOMONTH(DATEADD(MONTH, nos.monthnos, [DateCreated])-1)) as totaldays,month(EOMONTH(DATEADD(MONTH, nos.monthnos, [DateCreated])-1)) as monthOrder
from [dbo].[EmployeeMonthlyBudget]
inner join (SELECT 1 monthnos UNION SELECT 2 UNION SELECT 3
UNION SELECT 4 UNION SELECT 5 UNION SELECT 6
UNION SELECT 7 UNION SELECT 8 UNION SELECT 9
UNION SELECT 10 UNION SELECT 11 UNION SELECT 12) nos on nos.monthnos <= DATEDIFF(MONTH, [DateCreated],isnull([DateDeleted],GETDATE()))+1
 ) B on
A.NAME=B.Name 
order by A.Name,monthOrder" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0425047" StatementEstRows="7.2" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xBAD5F0539F253A85" QueryPlanHash="0x828DB3A5E44E6E71" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1600" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="88" CompileTime="0" CompileCPU="0" CompileMemory="592"><MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="1600" RequiredMemory="1536" DesiredMemory="1600" RequestedMemory="1600" GrantWaitTime="0" GrantedMemory="1600" MaxUsedMemory="184" MaxQueryMemory="623632"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="821216"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2018-10-26T05:37:16.91" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_34C8D9D1]" Table="[EmployeeMonthlyBudget]" Schema="[dbo]" Database="[fiddle_6d4719074ed64658889cc2499cbe876a]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="7.2" EstimateIO="0.0112613" EstimateCPU="0.00013206" AvgRowSize="71" EstimatedTotalSubtreeCost="0.0425047" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="544" OutputMemoryGrant="192" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1020"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="7.2" EstimateIO="0" EstimateCPU="7.2e-007" AvgRowSize="71" EstimatedTotalSubtreeCost="0.0311114" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference><ColumnReference Column="Expr1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="datename(month,dateadd(month,[Union1017],[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[DateCreated])-'1900-01-02 00:00:00.000')"><Intrinsic FunctionName="datename"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="'1900-01-02 00:00:00.000'"></Const></ScalarOperator></Arithmetic></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="datepart(month,eomonth(CONVERT_IMPLICIT(date,dateadd(month,[Union1017],[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[DateCreated])-'1900-01-02 00:00:00.000',0)))"><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Convert DataType="date" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="'1900-01-02 00:00:00.000'"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1021"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(money,datepart(day,eomonth(CONVERT_IMPLICIT(date,dateadd(month,[Union1017],[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[DateCreated])-'1900-01-02 00:00:00.000',0))),0)*[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[Budget_Day] as [A].[Budget_Day]"><Arithmetic Operation="MULT"><ScalarOperator><Convert DataType="money" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="datepart"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Convert DataType="date" Style="0" Implicit="1"><ScalarOperator><Arithmetic Operation="SUB"><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Union1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="'1900-01-02 00:00:00.000'"></Const></ScalarOperator></Arithmetic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="7.2" EstimateIO="0" EstimateCPU="0.017908" AvgRowSize="39" EstimatedTotalSubtreeCost="0.0311107" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1088" OutputMemoryGrant="1056" UsedMemoryGrant="176"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="Name"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[Name]=[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[Name] as [A].[Name]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="Name"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="3" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.003125" EstimateCPU="0.0001592" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032842" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="2" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" Column="Budget_Day"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Alias="[A]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="7.2" EstimateIO="0" EstimateCPU="0.00010032" AvgRowSize="73" EstimatedTotalSubtreeCost="0.0099155" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="[Union1017]<=(datediff(month,[fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[DateCreated],isnull([fiddle_6d4719074ed64658889cc2499cbe876a].[dbo].[EmployeeMonthlyBudget].[DateDeleted],getdate()))+(1))"><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Column="Union1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Intrinsic FunctionName="isnull"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateDeleted"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1022"><ScalarOperator><Intrinsic FunctionName="getdate"></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="5" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00561928" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="12" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00510855" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="11" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00459781" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="8" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00408707" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00357633" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="8" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00306559" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="7" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00255485" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="6" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="12" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00204411" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="5" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00153337" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.00102263" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="15" PhysicalOp="Merge Join" LogicalOp="Union" EstimateRows="12" EstimateIO="0" EstimateCPU="0.000509582" AvgRowSize="11" EstimatedTotalSubtreeCost="0.000511896" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="2" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Merge><DefinedValues><DefinedValue><ColumnReference Column="Union1017"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="16" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp><RelOp NodeId="17" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(2)"><Const ConstValue="(2)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="18" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1007"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(3)"><Const ConstValue="(3)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="19" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1008"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(4)"><Const ConstValue="(4)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="20" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(5)"><Const ConstValue="(5)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="21" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(6)"><Const ConstValue="(6)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="22" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1011"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(7)"><Const ConstValue="(7)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="23" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(8)"><Const ConstValue="(8)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="24" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="25" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1014"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(10)"><Const ConstValue="(10)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="26" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1015"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(11)"><Const ConstValue="(11)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="27" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="11" EstimatedTotalSubtreeCost="1.157e-006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1016"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(12)"><Const ConstValue="(12)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp></Merge></RelOp><RelOp NodeId="28" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="2" EstimatedRowsRead="2" EstimateIO="0.0032035" EstimateCPU="8.07e-005" AvgRowSize="77" EstimatedTotalSubtreeCost="0.0041719" TableCardinality="2" Parallel="0" EstimateRebinds="0" EstimateRewinds="11" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="Name"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateDeleted"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="24" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="12" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="24" ActualEndOfScans="12" ActualExecutions="12"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="Name"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateCreated"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" Column="DateDeleted"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_6d4719074ed64658889cc2499cbe876a]" Schema="[dbo]" Table="[EmployeeMonthlyBudget]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></NestedLoops></RelOp></Hash></RelOp></ComputeScalar></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML> |