SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[Warehouse](
        [ID] [int] NOT NULL
        ,[Flag] [nvarchar](1) NULL
	,[ArtNo] [nvarchar](30) NOT NULL
	,[Amount] [float] NULL
) ON [PRIMARY]
INSERT INTO [dbo].[Warehouse]
           ([ID]
           ,[Flag]
           ,[ArtNo]
           ,[Amount])
     VALUES
           (1,'U','A1000',-100),
           (2,'U','B2000',-5),
           (3,'V','B2000',900),
           (4,'U','B2000',-10),
           (5,'I','B2000',50),
           (6,'U','B2000',-20),
           (7,'U','A1000',-50),
           (8,'I','A1000',1000),
           (9,'V','A1000',3600),
           (10,'U','A1000',-500),
           (11,'U','A1000',-100),
           (12,'U','A1000',-2000),
           (13,'I','A1000',2000),
           (14,'U','A1000',-1000),
           (15,'I','C3000',10000),
           (16,'U','C3000',-4000),
           (17,'U','B2000',-5),
           (18,'U','B2000',-5),
           (19,'I','B2000',40),
           (20,'V','B2000',200),
           (21,'U','A1000',-500),
           (22,'U','B2000',-50),
           (23,'U','C3000',-1000)
23 rows affected

set statistics xml on;
with cte as
 (
   select *,
      -- find the latest 'V' ID per ArtNo
      max(case when Flag = 'V' then ID end) 
      over (partition by ArtNo) as Last_V_ID
   from [dbo].[Warehouse]
 )
select *,
   -- cumulative sum, but ignore all rows before the latest 'V' ID
   -- includes rows when there's no 'V' ID for this ArtNo
   sum(case when ID < Last_V_ID then null else Amount end)
   over (partition by ArtNo
         order by ID
         rows unbounded preceding)
   -- calculate in-stock based on last 'V' ID, discarding all previous 'V' rows
  ,sum(case when (ID < Last_V_ID and Flag <> 'V')  then -Amount 
            when ID = Last_V_ID then Amount 
       end)
   over (partition by ArtNo
         order by ID 
         rows between 1 following and unbounded following)
from cte
order by ArtNo, ID


ID
Flag
ArtNo
Amount
Last_V_ID
(No column name)
(No column name)


1
U
A1000
-100
9
null
2650

7
U
A1000
-50
9
null
2600

8
I
A1000
1000
9
null
3600

9
V
A1000
3600
9
3600
null

10
U
A1000
-500
9
3100
null

11
U
A1000
-100
9
3000
null

12
U
A1000
-2000
9
1000
null

13
I
A1000
2000
9
3000
null

14
U
A1000
-1000
9
2000
null

21
U
A1000
-500
9
1500
null

2
U
B2000
-5
20
null
150

3
V
B2000
900
20
null
150

4
U
B2000
-10
20
null
140

5
I
B2000
50
20
null
190

6
U
B2000
-20
20
null
170

17
U
B2000
-5
20
null
165

18
U
B2000
-5
20
null
160

19
I
B2000
40
20
null
200

20
V
B2000
200
20
200
null

22
U
B2000
-50
20
150
null

15
I
C3000
10000
null
10000
null

16
U
C3000
-4000
null
6000
null

23
U
C3000
-1000
null
5000
null


Warning: Null value is eliminated by an aggregate or other SET operation.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="with cte as&#xa; (&#xa;   select *,&#xa;      -- find the latest &apos;V&apos; ID per ArtNo&#xa;      max(case when Flag = &apos;V&apos; then ID end) &#xa;      over (partition by ArtNo) as Last_V_ID&#xa;   from [dbo].[Warehouse]&#xa; )&#xa;select *,&#xa;   -- cumulative sum, but ignore all rows before the latest &apos;V&apos; ID&#xa;   -- includes rows when there&apos;s no &apos;V&apos; ID for this ArtNo&#xa;   sum(case when ID &lt; Last_V_ID then null else Amount end)&#xa;   over (partition by ArtNo&#xa;         order by ID&#xa;         rows unbounded preceding)&#xa;   -- calculate in-stock based on last &apos;V&apos; ID, discarding all previous &apos;V&apos; rows&#xa;  ,sum(case when (ID &lt; Last_V_ID and Flag &lt;&gt; &apos;V&apos;)  then -Amount &#xa;            when ID = Last_V_ID then Amount &#xa;       end)&#xa;   over (partition by ArtNo&#xa;         order by ID &#xa;         rows between 1 following and unbounded following)&#xa;from cte&#xa;order by ArtNo, ID" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0384976" StatementEstRows="23" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x10E32B74C0E2DAC5" QueryPlanHash="0x5055E0FC1F067C95" 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="1248" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="112" CompileTime="15" CompileCPU="15" CompileMemory="576"><MemoryGrantInfo SerialRequiredMemory="1152" SerialDesiredMemory="1248" RequiredMemory="1152" DesiredMemory="1248" RequestedMemory="1248" GrantWaitTime="0" GrantedMemory="1248" MaxUsedMemory="24" MaxQueryMemory="478472"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="790728"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-10-29T10:03:52.52" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_34C8D9D1]" Table="[Warehouse]" Schema="[dbo]" Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]"></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="23" EstimateIO="0.0112613" EstimateCPU="0.000262361" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0384976" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><MemoryFractions Input="0.333333" Output="0.666667"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" 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_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="2.3e-006" AvgRowSize="56" EstimatedTotalSubtreeCost="0.026974" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1019]=(0) THEN NULL ELSE [Expr1020] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1020"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="23" EstimateIO="0" EstimateCPU="1.4444e-005" AvgRowSize="72" EstimatedTotalSubtreeCost="0.0269717" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Expr1019"></ColumnReference><ColumnReference Column="Expr1020"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1019"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG(CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]&lt;[Expr1004] AND [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Flag]&lt;&gt;N&apos;V&apos; THEN  -[fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] ELSE CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]=[Expr1004] THEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] ELSE NULL END END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;V&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1020"></ColumnReference><ScalarOperator ScalarString="SUM(CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]&lt;[Expr1004] AND [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Flag]&lt;&gt;N&apos;V&apos; THEN  -[fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] ELSE CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]=[Expr1004] THEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] ELSE NULL END END)"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;V&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Condition><Then><ScalarOperator><Arithmetic Operation="MINUS"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></Then><Else><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Flag])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1004])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1007])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1033"></ColumnReference></GroupBy><RelOp NodeId="3" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="46" EstimateIO="0" EstimateCPU="5.0554e-005" AvgRowSize="72" EstimatedTotalSubtreeCost="0.0269572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="RowNumber1025"></ColumnReference><ColumnReference Column="WindowCount1033"></ColumnReference><ColumnReference Column="Segment1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="43" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="23" EstimateIO="0" EstimateCPU="1.4444e-006" AvgRowSize="72" EstimatedTotalSubtreeCost="0.0269009" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="RowNumber1025"></ColumnReference><ColumnReference Column="BottomRowNumber1026"></ColumnReference><ColumnReference Column="Segment1032"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1032"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="2.3e-006" AvgRowSize="64" EstimatedTotalSubtreeCost="0.0268995" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="RowNumber1025"></ColumnReference><ColumnReference Column="BottomRowNumber1026"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="BottomRowNumber1026"></ColumnReference><ScalarOperator ScalarString="[RowNumber1025]-(1)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1025"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="1.84e-006" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0268972" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="RowNumber1025"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1025"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="23" EstimateIO="0" EstimateCPU="4.6e-007" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0268953" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Segment1031"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1031"></ColumnReference></SegmentColumn><RelOp NodeId="8" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="23" EstimateIO="0.0112613" EstimateCPU="0.000262353" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0268949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><MemoryFractions Input="0.666667" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" 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="576" OutputMemoryGrant="160" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="2.3e-006" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0153712" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1017]=(0) THEN NULL ELSE [Expr1018] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="Expr1018"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="23" EstimateIO="0" EstimateCPU="1.4444e-005" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0153689" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1017"></ColumnReference><ColumnReference Column="Expr1018"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1017"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG(CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]&lt;[Expr1004] THEN NULL ELSE [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1018"></ColumnReference><ScalarOperator ScalarString="SUM(CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID]&lt;[Expr1004] THEN NULL ELSE [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount] END)"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Flag])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ScalarOperator ScalarString="ANY([fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Amount])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1004])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1030"></ColumnReference></GroupBy><RelOp NodeId="11" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="46" EstimateIO="0" EstimateCPU="5.0554e-005" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0153545" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="RowNumber1024"></ColumnReference><ColumnReference Column="WindowCount1030"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="46" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="12" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="23" EstimateIO="0" EstimateCPU="1.4444e-006" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0152982" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="RowNumber1024"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1029"></ColumnReference></SegmentColumn><RelOp NodeId="13" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="1.84e-006" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0152967" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="RowNumber1024"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1024"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="23" EstimateIO="0" EstimateCPU="4.6e-007" AvgRowSize="48" EstimatedTotalSubtreeCost="0.0152949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Segment1028"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1028"></ColumnReference></SegmentColumn><RelOp NodeId="15" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="23" EstimateIO="0" EstimateCPU="0.000355124" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0152944" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="16" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="3" EstimateIO="0" EstimateCPU="0" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0149255" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="4" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="47" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Spool><RelOp NodeId="17" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="23" EstimateIO="0" EstimateCPU="4.612e-005" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0148793" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Segment1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1027"></ColumnReference></SegmentColumn><RelOp NodeId="18" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="23" EstimateIO="0" EstimateCPU="2.3e-006" AvgRowSize="60" EstimatedTotalSubtreeCost="0.0148332" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[Flag]=N&apos;V&apos; THEN [fiddle_294561c7341f4ad28dbf7695b0b401cc].[dbo].[Warehouse].[ID] ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="N&apos;V&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="19" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="23" EstimateIO="0.0112613" EstimateCPU="0.000262361" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0148309" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></OutputList><MemoryFractions Input="0.333333" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" 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="160" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="20" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="23" EstimatedRowsRead="23" EstimateIO="0.003125" EstimateCPU="0.0001823" AvgRowSize="56" EstimatedTotalSubtreeCost="0.0033073" TableCardinality="23" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="23" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></Sort></RelOp></ComputeScalar></RelOp></Segment></RelOp></Spool></RelOp><RelOp NodeId="21" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.612e-006" AvgRowSize="60" EstimatedTotalSubtreeCost="9.224e-006" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><Predicate><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator></Predicate><RelOp NodeId="22" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="1" EstimateIO="0" EstimateCPU="4.612e-006" AvgRowSize="60" EstimatedTotalSubtreeCost="4.612e-006" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="3" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1009])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="23" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="60" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" 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="3" ActualEndOfScans="4" ActualExecutions="4"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="16"></Spool></RelOp></StreamAggregate></RelOp><RelOp NodeId="24" PhysicalOp="Table Spool" LogicalOp="Lazy Spool" EstimateRows="1" EstimateIO="0" EstimateCPU="0" AvgRowSize="60" EstimatedTotalSubtreeCost="0" Parallel="0" EstimateRebinds="3" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ID"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Flag"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="ArtNo"></ColumnReference><ColumnReference Database="[fiddle_294561c7341f4ad28dbf7695b0b401cc]" Schema="[dbo]" Table="[Warehouse]" Column="Amount"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="23" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="0" ActualRewinds="3" ActualEndOfScans="3" ActualExecutions="3"></RunTimeCountersPerThread></RunTimeInformation><Spool PrimaryNodeId="16"></Spool></RelOp></NestedLoops></RelOp></NestedLoops></RelOp></Segment></RelOp></SequenceProject></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Sort></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
ID	Flag	ArtNo	Amount	Last_V_ID	(No column name)	(No column name)
1	U	A1000	-100	9	null	2650
7	U	A1000	-50	9	null	2600
8	I	A1000	1000	9	null	3600
9	V	A1000	3600	9	3600	null
10	U	A1000	-500	9	3100	null
11	U	A1000	-100	9	3000	null
12	U	A1000	-2000	9	1000	null
13	I	A1000	2000	9	3000	null
14	U	A1000	-1000	9	2000	null
21	U	A1000	-500	9	1500	null
2	U	B2000	-5	20	null	150
3	V	B2000	900	20	null	150
4	U	B2000	-10	20	null	140
5	I	B2000	50	20	null	190
6	U	B2000	-20	20	null	170
17	U	B2000	-5	20	null	165
18	U	B2000	-5	20	null	160
19	I	B2000	40	20	null	200
20	V	B2000	200	20	200	null
22	U	B2000	-50	20	150	null
15	I	C3000	10000	null	10000	null
16	U	C3000	-4000	null	6000	null
23	U	C3000	-1000	null	5000	null