SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT *
INTO dbo.YourTable
FROM (VALUES(CONVERT(date,'2024-02-20'), CONVERT(decimal(18,4),250)),
            (CONVERT(date,'2024-02-12'), CONVERT(decimal(18,4),80)),
            (CONVERT(date,'2024-02-01'), CONVERT(decimal(18,4),420)))V(DateOfDay,Balance);
3 rows affected

SET STATISTICS XML ON;
WITH DateBoundaries AS (
    SELECT MIN(DateOfDay) AS StartDate,
           EOMONTH(GETDATE()) AS EndDate
    FROM dbo.YourTable),
Dates AS(
    SELECT DATEADD(DAY, GS.value,DB.StartDate) AS CalendarDate
    FROM DateBoundaries DB
         CROSS APPLY GENERATE_SERIES(0,DATEDIFF(DAY,DB.StartDate,DB.EndDate)) GS)
SELECT D.CalendarDate,
       LAST_VALUE(YT.Balance) IGNORE NULLS OVER (ORDER BY D.CalendarDate) AS Profit
FROM Dates D
     LEFT JOIN dbo.YourTable YT ON D.CalendarDate = YT.DateOfDay
ORDER BY D.CalendarDate DESC;


CalendarDate
Profit


2024-02-29
250.0000

2024-02-28
250.0000

2024-02-27
250.0000

2024-02-26
250.0000

2024-02-25
250.0000

2024-02-24
250.0000

2024-02-23
250.0000

2024-02-22
250.0000

2024-02-21
250.0000

2024-02-20
250.0000

2024-02-19
80.0000

2024-02-18
80.0000

2024-02-17
80.0000

2024-02-16
80.0000

2024-02-15
80.0000

2024-02-14
80.0000

2024-02-13
80.0000

2024-02-12
80.0000

2024-02-11
420.0000

2024-02-10
420.0000

2024-02-09
420.0000

2024-02-08
420.0000

2024-02-07
420.0000

2024-02-06
420.0000

2024-02-05
420.0000

2024-02-04
420.0000

2024-02-03
420.0000

2024-02-02
420.0000

2024-02-01
420.0000




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH DateBoundaries AS (&#xa;    SELECT MIN(DateOfDay) AS StartDate,&#xa;           EOMONTH(GETDATE()) AS EndDate&#xa;    FROM dbo.YourTable),&#xa;Dates AS(&#xa;    SELECT DATEADD(DAY, GS.value,DB.StartDate) AS CalendarDate&#xa;    FROM DateBoundaries DB&#xa;         CROSS APPLY GENERATE_SERIES(0,DATEDIFF(DAY,DB.StartDate,DB.EndDate)) GS)&#xa;SELECT D.CalendarDate,&#xa;       LAST_VALUE(YT.Balance) IGNORE NULLS OVER (ORDER BY D.CalendarDate) AS Profit&#xa;FROM Dates D&#xa;     LEFT JOIN dbo.YourTable YT ON D.CalendarDate = YT.DateOfDay&#xa;ORDER BY D.CalendarDate DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x0900E54B3A9CF7A28BBACDCA666D51AED8E90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0353942" StatementEstRows="52.82" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xB75C885EEA19B76C" QueryPlanHash="0xBC19FF7CE1314C39" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="0" CompileCPU="0" CompileMemory="464"><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" RequiredMemory="640" DesiredMemory="704" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="768624" GrantedMemory="1024" MaxUsedMemory="24"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1402968"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-12T13:09:06.92" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_35BCFE0A]" Table="[YourTable]" Schema="[dbo]" Database="[fiddle_e212161891684af59ce8c202566ccb90]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="52.82" EstimateIO="0.0112613" EstimateCPU="0.000571591" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0353942" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" 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="704" OutputMemoryGrant="512" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Column="Expr1005"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="52.82" EstimateIO="0" EstimateCPU="3.3171e-05" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0235613" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE_IGNORE_NULLS([fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[Balance] as [YT].[Balance])"><Aggregate Distinct="0" AggType="LAST_VALUE_IGNORE_NULLS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1005])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1014"></ColumnReference></GroupBy><RelOp NodeId="2" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="105.64" EstimateIO="0" EstimateCPU="0.000116098" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0235282" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference><ColumnReference Column="WindowCount1014"></ColumnReference><ColumnReference Column="Segment1012"></ColumnReference><ColumnReference Column="Segment1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="58" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="52.82" EstimateIO="0" EstimateCPU="0" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0233988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference><ColumnReference Column="Segment1012"></ColumnReference><ColumnReference Column="Segment1013"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Column="Expr1005"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1013"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="52.82" EstimateIO="0" EstimateCPU="3.3171e-06" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0233988" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference><ColumnReference Column="Segment1012"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1012"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="52.82" EstimateIO="0.0112613" EstimateCPU="0.000571591" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0233955" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" 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="896" OutputMemoryGrant="320" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Column="Expr1005"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="52.82" EstimateIO="0" EstimateCPU="5.282e-06" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0115626" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="dateadd(day,GENERATE_SERIES.[value],[Expr1003])"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="52.82" EstimateIO="0" EstimateCPU="0.000627" AvgRowSize="23" EstimatedTotalSubtreeCost="0.0115574" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="dateadd(day,GENERATE_SERIES.[value],[Expr1003])=[fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[DateOfDay] as [YT].[DateOfDay]"><Compare CompareOp="EQ"><ScalarOperator><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="DateOfDay"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="50" EstimateIO="0" EstimateCPU="0.000209" AvgRowSize="14" EstimatedTotalSubtreeCost="0.00354686" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OuterReferences><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="13" EstimatedTotalSubtreeCost="0.0032877" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="eomonth(CONVERT_IMPLICIT(date,getdate(),0))"><Identifier><ColumnReference Column="ConstExpr1009"><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Convert DataType="date" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="getdate"></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.3e-06" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032876" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="MIN([fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[DateOfDay])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="12" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="50" EstimateIO="0" EstimateCPU="5.0157e-05" AvgRowSize="11" EstimatedTotalSubtreeCost="5.0157e-05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Table="[GENERATE_SERIES]" Column="value"></ColumnReference></DefinedValue></DefinedValues><Object Table="[GENERATE_SERIES]"></Object><ParameterList><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator><ScalarOperator ScalarString="datediff(day,CONVERT_IMPLICIT(datetimeoffset(7),[Expr1003],0),CONVERT_IMPLICIT(datetimeoffset(7),[Expr1004],0))"><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Convert DataType="datetimeoffset" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetimeoffset" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></ParameterList></TableValuedFunction></RelOp></NestedLoops></RelOp><RelOp NodeId="13" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.0032035" EstimateCPU="8.18e-05" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0072935" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="49" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="DateOfDay"></ColumnReference><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="87" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="29" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="87" ActualEndOfScans="29" ActualExecutions="29" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="DateOfDay"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


WITH DateBoundaries AS (
    SELECT MIN(DateOfDay) AS StartDate,
           EOMONTH(GETDATE()) AS EndDate
    FROM dbo.YourTable),
N AS(
    SELECT N
    FROM (VALUES(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))N(N)),
Tally AS(
    SELECT 0 AS I
    UNION ALL
    SELECT TOP (SELECT DATEDIFF(DAY,DB.StartDate,DB.EndDate) FROM DateBoundaries DB)
           ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    FROM N N1, N N2,N N3), --UP to 1,000 days
Dates AS(
    SELECT DATEADD(DAY, T.I,DB.StartDate) AS CalendarDate
    FROM DateBoundaries DB
         CROSS JOIN Tally T)
SELECT D.CalendarDate,
       B.Balance AS Profit
FROM Dates D
     OUTER APPLY (SELECT TOP (1) YT.Balance
                  FROM dbo.YourTable YT
                  WHERE YT.DateOfDay <= D.CalendarDate) B
ORDER BY D.CalendarDate DESC;


CalendarDate
Profit


2024-02-29
250.0000

2024-02-28
250.0000

2024-02-27
250.0000

2024-02-26
250.0000

2024-02-25
250.0000

2024-02-24
250.0000

2024-02-23
250.0000

2024-02-22
250.0000

2024-02-21
250.0000

2024-02-20
250.0000

2024-02-19
80.0000

2024-02-18
80.0000

2024-02-17
80.0000

2024-02-16
80.0000

2024-02-15
80.0000

2024-02-14
80.0000

2024-02-13
80.0000

2024-02-12
80.0000

2024-02-11
420.0000

2024-02-10
420.0000

2024-02-09
420.0000

2024-02-08
420.0000

2024-02-07
420.0000

2024-02-06
420.0000

2024-02-05
420.0000

2024-02-04
420.0000

2024-02-03
420.0000

2024-02-02
420.0000

2024-02-01
420.0000




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH DateBoundaries AS (&#xa;    SELECT MIN(DateOfDay) AS StartDate,&#xa;           EOMONTH(GETDATE()) AS EndDate&#xa;    FROM dbo.YourTable),&#xa;N AS(&#xa;    SELECT N&#xa;    FROM (VALUES(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))N(N)),&#xa;Tally AS(&#xa;    SELECT 0 AS I&#xa;    UNION ALL&#xa;    SELECT TOP (SELECT DATEDIFF(DAY,DB.StartDate,DB.EndDate) FROM DateBoundaries DB)&#xa;           ROW_NUMBER() OVER (ORDER BY (SELECT NULL))&#xa;    FROM N N1, N N2,N N3), --UP to 1,000 days&#xa;Dates AS(&#xa;    SELECT DATEADD(DAY, T.I,DB.StartDate) AS CalendarDate&#xa;    FROM DateBoundaries DB&#xa;         CROSS JOIN Tally T)&#xa;SELECT D.CalendarDate,&#xa;       B.Balance AS Profit&#xa;FROM Dates D&#xa;     OUTER APPLY (SELECT TOP (1) YT.Balance&#xa;                  FROM dbo.YourTable YT&#xa;                  WHERE YT.DateOfDay &lt;= D.CalendarDate) B&#xa;ORDER BY D.CalendarDate DESC" StatementId="1" StatementCompId="1" StatementType="SELECT" StatementSqlHandle="0x09009F890423A4C1DC3AA3F72B7DCAC954750000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="1" ParentObjectId="0" StatementParameterizationType="0" RetrievedFromCache="true" StatementSubTreeCost="0.0325169" StatementEstRows="101" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xE23B63E7D2770C94" QueryPlanHash="0x521C0CCE0C2BC1B1" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><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="1024" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="15" CompileCPU="15" CompileMemory="1272"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" MaxQueryMemory="768624" GrantedMemory="1024" MaxUsedMemory="16"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1402968"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-02-12T13:09:06.92" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_35BCFE0A]" Table="[YourTable]" Schema="[dbo]" Database="[fiddle_e212161891684af59ce8c202566ccb90]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="101" EstimateIO="0" EstimateCPU="0.00042218" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0325169" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1049"></ColumnReference><ColumnReference Column="Expr1052"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1049"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="101" EstimateIO="0.0112613" EstimateCPU="0.00114908" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0204435" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1049"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" 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="1024" OutputMemoryGrant="640" UsedMemoryGrant="16" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="0"><ColumnReference Column="Expr1049"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="2" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="101" EstimateIO="0" EstimateCPU="1.01e-05" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0080332" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1049"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1049"></ColumnReference><ScalarOperator ScalarString="dateadd(day,CONVERT_IMPLICIT(int,[Union1048],0),[Expr1003])"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Union1048"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="101" EstimateIO="0" EstimateCPU="0.00042218" AvgRowSize="18" EstimatedTotalSubtreeCost="0.0080231" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Union1048"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.3e-06" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032876" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1003"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="MIN([fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[DateOfDay])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="5" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" TableReferenceId="1" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></StreamAggregate></RelOp><RelOp NodeId="6" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="101" EstimateIO="0" EstimateCPU="1.01e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00431332" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Union1048"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Concat><DefinedValues><DefinedValue><ColumnReference Column="Union1048"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1041"></ColumnReference></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-06" AvgRowSize="15" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan><Values><Row><ScalarOperator ScalarString="(0)"><Const ConstValue="(0)"></Const></ScalarOperator></Row></Values></ConstantScan></RelOp><RelOp NodeId="8" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="100" EstimateIO="0" EstimateCPU="0.000418" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00430206" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Column="Expr1055"></ColumnReference></OuterReferences><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="15" EstimatedTotalSubtreeCost="0.0032877" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1055"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1055"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(bigint,datediff(day,CONVERT_IMPLICIT(datetimeoffset(7),[Expr1045],0),CONVERT_IMPLICIT(datetimeoffset(7),eomonth(CONVERT_IMPLICIT(date,getdate(),0)),0)),0)"><Convert DataType="bigint" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Convert DataType="datetimeoffset" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1045"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetimeoffset" Scale="7" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1054"><ScalarOperator><Intrinsic FunctionName="eomonth"><ScalarOperator><Convert DataType="date" Style="0" Implicit="1"><ScalarOperator><Intrinsic FunctionName="getdate"></Intrinsic></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Const ConstValue=""></Const></ScalarOperator></Intrinsic></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Intrinsic></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="2.3e-06" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032876" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1045"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1045"></ColumnReference><ScalarOperator ScalarString="MIN([fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[DateOfDay])"><Aggregate Distinct="0" AggType="MIN"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="3" EstimatedRowsRead="3" EstimateIO="0.003125" EstimateCPU="0.0001603" AvgRowSize="10" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="3" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Column="DateOfDay"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" TableReferenceId="2" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><RelOp NodeId="12" PhysicalOp="Top" LogicalOp="Top" EstimateRows="100" EstimateIO="0" EstimateCPU="1e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.000596363" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="[Expr1055]"><Identifier><ColumnReference Column="Expr1055"></ColumnReference></Identifier></ScalarOperator></TopExpression><RelOp NodeId="13" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="100" EstimateRowsWithoutRowGoal="1000" EstimateIO="0" EstimateCPU="8e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.000586363" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1041"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1041"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="100" EstimateRowsWithoutRowGoal="1000" EstimateIO="0" EstimateCPU="2e-05" AvgRowSize="15" EstimatedTotalSubtreeCost="0.000578363" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Segment1058"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy></GroupBy><SegmentColumn><ColumnReference Column="Segment1058"></ColumnReference></SegmentColumn><RelOp NodeId="15" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="100" EstimateRowsWithoutRowGoal="1000" EstimateIO="0" EstimateCPU="0.00418" AvgRowSize="9" EstimatedTotalSubtreeCost="0.000576363" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="16" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="10" EstimateRowsWithoutRowGoal="100" EstimateIO="0" EstimateCPU="0.000418" AvgRowSize="9" EstimatedTotalSubtreeCost="5.39322e-05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><Warnings NoJoinPredicate="1"></Warnings><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="17" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateRowsWithoutRowGoal="10" EstimateIO="0" EstimateCPU="1.0157e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="1.157e-06" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><RelOp NodeId="18" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="10" EstimateRowsWithoutRowGoal="10" EstimateIO="0" EstimateCPU="1.0157e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="1.0157e-05" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp><RelOp NodeId="19" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="10" EstimateRowsWithoutRowGoal="10" EstimateIO="0" EstimateCPU="1.0157e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="0.000109157" Parallel="0" EstimateRebinds="0" EstimateRewinds="9.9" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="2" ActualExecutions="3" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp></NestedLoops></RelOp></Segment></RelOp></SequenceProject></RelOp></Top></RelOp></NestedLoops></RelOp></Concat></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Sort></RelOp><RelOp NodeId="20" PhysicalOp="Top" LogicalOp="Top" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-07" AvgRowSize="16" EstimatedTotalSubtreeCost="0.0116511" Parallel="0" EstimateRebinds="0" EstimateRewinds="100" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1052"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="29" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Top RowCount="0" IsPercent="0" WithTies="0"><TopExpression><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></TopExpression><RelOp NodeId="21" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="3e-07" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0114956" Parallel="0" EstimateRebinds="0" EstimateRewinds="100" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1052"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1052"></ColumnReference><ScalarOperator ScalarString="[fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[Balance] as [YT].[Balance]"><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="22" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="1" EstimatedRowsRead="3" EstimateIO="0.0032035" EstimateCPU="8.18e-05" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0114653" TableCardinality="3" Parallel="0" EstimateRebinds="0" EstimateRewinds="100" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="29" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="29" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="59" ActualEndOfScans="0" ActualExecutions="29" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="Balance"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" IndexKind="Heap" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_e212161891684af59ce8c202566ccb90].[dbo].[YourTable].[DateOfDay] as [YT].[DateOfDay]&lt;=[Expr1049]"><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_e212161891684af59ce8c202566ccb90]" Schema="[dbo]" Table="[YourTable]" Alias="[YT]" Column="DateOfDay"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1049"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></TableScan></RelOp></ComputeScalar></RelOp></Top></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


SET STATISTICS XML OFF;
DROP TABLE dbo.YourTable;
CalendarDate	Profit
2024-02-29	250.0000
2024-02-28	250.0000
2024-02-27	250.0000
2024-02-26	250.0000
2024-02-25	250.0000
2024-02-24	250.0000
2024-02-23	250.0000
2024-02-22	250.0000
2024-02-21	250.0000
2024-02-20	250.0000
2024-02-19	80.0000
2024-02-18	80.0000
2024-02-17	80.0000
2024-02-16	80.0000
2024-02-15	80.0000
2024-02-14	80.0000
2024-02-13	80.0000
2024-02-12	80.0000
2024-02-11	420.0000
2024-02-10	420.0000
2024-02-09	420.0000
2024-02-08	420.0000
2024-02-07	420.0000
2024-02-06	420.0000
2024-02-05	420.0000
2024-02-04	420.0000
2024-02-03	420.0000
2024-02-02	420.0000
2024-02-01	420.0000