SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE IF EXISTS #TempFuelPurchase;

CREATE TABLE #TempFuelPurchase (
    Account_Number INT,
    FuelPurchase_Date DATE,
    Fuel_TOD TIME
);

INSERT INTO #TempFuelPurchase (Account_Number, FuelPurchase_Date, Fuel_TOD)
VALUES
    (19, '2024-04-03', '07:02:02 AM'),
    (19, '2024-04-03', '07:02:41 AM'),
    (19, '2024-04-03', '02:58:49 PM'),
    (19, '2024-04-03', '07:58:49 PM'),
    (19, '2024-04-05', '02:58:49 PM'),
    (19, '2024-04-05', '02:59:31 PM'),
    (19, '2024-04-17', '11:56:13 PM'),
    (20, '2024-04-17', '11:59:13 PM'),
    (19, '2024-04-18', '12:15:13 AM'),
    (19, '2024-04-18', '02:56:13 PM'),
    (20, '2024-04-18', '07:41:55 AM'),
    (20, '2024-04-18', '07:41:55 PM'),
    (20, '2024-04-18', '07:56:55 PM'),
    (19, '2024-04-19', '07:41:55 AM'),
    (19, '2024-04-19', '07:42:20 AM');


DROP TABLE IF EXISTS #DesiredOutput;

CREATE TABLE #DesiredOutput (
    Account_Number INT,
    FuelPurchase_Date DATE,
    Fuel_TOD TIME,
    Seq Int
);

INSERT INTO #DesiredOutput (Account_Number, FuelPurchase_Date, Fuel_TOD, Seq)
VALUES
    (19, '2024-04-03', '07:02:02 AM',1),
    (19, '2024-04-03', '07:02:41 AM',2),
    (19, '2024-04-03', '02:58:49 PM',1),
    (19, '2024-04-03', '07:58:49 PM',1),
    (19, '2024-04-05', '02:58:49 PM',1),
    (19, '2024-04-05', '02:59:31 PM',2),
    (19, '2024-04-17', '11:56:13 PM',1),
    (20, '2024-04-17', '11:59:13 PM',1),
    (19, '2024-04-18', '12:15:13 AM',2),
    (19, '2024-04-18', '02:56:13 PM',1),
    (20, '2024-04-18', '07:41:55 AM',1),
    (20, '2024-04-18', '07:41:55 PM',1),
    (20, '2024-04-18', '07:56:55 PM',2),
    (19, '2024-04-19', '07:41:55 AM',1),
    (19, '2024-04-19', '07:42:20 AM',2);
30 rows affected

set statistics xml on;
with dataX as (
    select *,
        cast(FuelPurchase_Date as datetime) + cast(Fuel_TOD as datetime) as Fuel_DT
    from #TempFuelPurchase
), dataY as (
    select *,
        row_number() over (partition by Account_Number order by Fuel_DT) as rn,
        lag(Fuel_DT, 1, dateadd(day, -1, Fuel_DT)) over (partition by Account_Number order by Fuel_DT) as last_DT
    from dataX
), dataZ as (
    select *,
        case when datediff(second, last_DT, Fuel_DT) > 3600 then rn end as brk
    from dataY
)
select Account_Number, FuelPurchase_Date, Fuel_TOD,
    rn + 1 - max(brk) over (partition by Account_Number order by Fuel_DT) as Seq
from dataZ;


Account_Number
FuelPurchase_Date
Fuel_TOD
Seq


19
2024-04-03
07:02:02.0000000
1

19
2024-04-03
07:02:41.0000000
2

19
2024-04-03
14:58:49.0000000
1

19
2024-04-03
19:58:49.0000000
1

19
2024-04-05
14:58:49.0000000
1

19
2024-04-05
14:59:31.0000000
2

19
2024-04-17
23:56:13.0000000
1

19
2024-04-18
00:15:13.0000000
2

19
2024-04-18
14:56:13.0000000
1

19
2024-04-19
07:41:55.0000000
1

19
2024-04-19
07:42:20.0000000
2

20
2024-04-17
23:59:13.0000000
1

20
2024-04-18
07:41:55.0000000
1

20
2024-04-18
19:41:55.0000000
1

20
2024-04-18
19:56:55.0000000
2


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.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="with dataX as (&#xa;    select *,&#xa;        cast(FuelPurchase_Date as datetime) + cast(Fuel_TOD as datetime) as Fuel_DT&#xa;    from #TempFuelPurchase&#xa;), dataY as (&#xa;    select *,&#xa;        row_number() over (partition by Account_Number order by Fuel_DT) as rn,&#xa;        lag(Fuel_DT, 1, dateadd(day, -1, Fuel_DT)) over (partition by Account_Number order by Fuel_DT) as last_DT&#xa;    from dataX&#xa;), dataZ as (&#xa;    select *,&#xa;        case when datediff(second, last_DT, Fuel_DT) &gt; 3600 then rn end as brk&#xa;    from dataY&#xa;)&#xa;select Account_Number, FuelPurchase_Date, Fuel_TOD,&#xa;    rn + 1 - max(brk) over (partition by Account_Number order by Fuel_DT) as Seq&#xa;from dataZ" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0148544" StatementEstRows="15" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x425B8DCE00F28D55" QueryPlanHash="0xEE0A5310B95E5DAE" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><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="88" CompileTime="0" CompileCPU="0" CompileMemory="544"><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="544" RequiredMemory="512" DesiredMemory="544" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="16" MaxQueryMemory="194576"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="650288"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-04-24T23:33:29.53" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_BAB70385]" Table="[#TempFuelPurchase___________________________________________________________________________________________________0000000000C3]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0148544" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[Expr1005]+(1)-[Expr1008]"><Arithmetic Operation="SUB"><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-006" AvgRowSize="59" EstimatedTotalSubtreeCost="0.0148529" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="MAX(CASE WHEN datediff(second,[Expr1006],[Expr1003])&gt;(3600) THEN [Expr1005] ELSE NULL END)"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(3600)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></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="WindowCount1031"></ColumnReference></GroupBy><RelOp NodeId="2" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="30" EstimateIO="0" EstimateCPU="3.297e-005" AvgRowSize="59" EstimatedTotalSubtreeCost="0.0148435" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="WindowCount1031"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference><ColumnReference Column="Segment1030"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="30" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="0" AvgRowSize="59" EstimatedTotalSubtreeCost="0.0148068" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference><ColumnReference Column="Segment1030"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1030"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-007" AvgRowSize="51" EstimatedTotalSubtreeCost="0.0148068" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1029"></ColumnReference></SegmentColumn><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0148058" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Count1018]=(0) THEN [Expr1011] ELSE [LastValue1017] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Count1018"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="LastValue1017"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-006" AvgRowSize="84" EstimatedTotalSubtreeCost="0.0148043" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="LastValue1017"></ColumnReference><ColumnReference Column="Count1018"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Count1018"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="LastValue1017"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE([Expr1003])"><Aggregate Distinct="0" AggType="LAST_VALUE"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1003])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></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><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1011])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1028"></ColumnReference></GroupBy><RelOp NodeId="7" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="30" EstimateIO="0" EstimateCPU="3.297e-005" AvgRowSize="84" EstimatedTotalSubtreeCost="0.0147949" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="RowNumber1019"></ColumnReference><ColumnReference Column="WindowCount1028"></ColumnReference><ColumnReference Column="Segment1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="8" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-007" AvgRowSize="84" EstimatedTotalSubtreeCost="0.0147582" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="RowNumber1019"></ColumnReference><ColumnReference Column="TopRowNumber1020"></ColumnReference><ColumnReference Column="BottomRowNumber1021"></ColumnReference><ColumnReference Column="Segment1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1027"></ColumnReference></SegmentColumn><RelOp NodeId="9" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="76" EstimatedTotalSubtreeCost="0.0147572" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="RowNumber1019"></ColumnReference><ColumnReference Column="TopRowNumber1020"></ColumnReference><ColumnReference Column="BottomRowNumber1021"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="TopRowNumber1020"></ColumnReference><ScalarOperator ScalarString="[RowNumber1019]-(1)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="BottomRowNumber1021"></ColumnReference><ScalarOperator ScalarString="[RowNumber1019]-(1)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1019"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="10" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.2e-006" AvgRowSize="59" EstimatedTotalSubtreeCost="0.0147557" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="RowNumber1019"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1019"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="11" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="3e-007" AvgRowSize="59" EstimatedTotalSubtreeCost="0.0147545" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Segment1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1026"></ColumnReference></SegmentColumn><RelOp NodeId="12" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.2e-006" AvgRowSize="51" EstimatedTotalSubtreeCost="0.0147542" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="3e-007" AvgRowSize="51" EstimatedTotalSubtreeCost="0.014753" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference><ColumnReference Column="Segment1025"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1025"></ColumnReference></SegmentColumn><RelOp NodeId="15" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="15" EstimateIO="0.0112613" EstimateCPU="0.000191464" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0147527" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1024" OutputMemoryGrant="640" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="16" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0)"><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0)"><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="dateadd(day,(-1),CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0))"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="17" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="0.0001735" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0032985" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>


set statistics xml on;
with dataX as (
    select *,
        cast(FuelPurchase_Date as datetime) + cast(Fuel_TOD as datetime) as Fuel_DT
    from #TempFuelPurchase
), dataY as (
    select *,
        lag(Fuel_DT, 1, dateadd(day, -1, Fuel_DT)) over (partition by Account_Number order by Fuel_DT) as last_DT
    from dataX
), dataZ as (
    select *,
        sum(
            case when datediff(second, last_DT, Fuel_DT) > 3600 then 1 end
           ) over (partition by Account_Number order by Fuel_DT) as grp
    from dataY
)
select Account_Number, FuelPurchase_Date, Fuel_TOD,
    row_number() over (partition by Account_Number, grp order by Fuel_DT) as Seq
from dataZ;


Account_Number
FuelPurchase_Date
Fuel_TOD
Seq


19
2024-04-03
07:02:02.0000000
1

19
2024-04-03
07:02:41.0000000
2

19
2024-04-03
14:58:49.0000000
1

19
2024-04-03
19:58:49.0000000
1

19
2024-04-05
14:58:49.0000000
1

19
2024-04-05
14:59:31.0000000
2

19
2024-04-17
23:56:13.0000000
1

19
2024-04-18
00:15:13.0000000
2

19
2024-04-18
14:56:13.0000000
1

19
2024-04-19
07:41:55.0000000
1

19
2024-04-19
07:42:20.0000000
2

20
2024-04-17
23:59:13.0000000
1

20
2024-04-18
07:41:55.0000000
1

20
2024-04-18
19:41:55.0000000
1

20
2024-04-18
19:56:55.0000000
2


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.518" Build="13.0.6404.1"><BatchSequence><Batch><Statements><StmtSimple StatementText="with dataX as (&#xa;    select *,&#xa;        cast(FuelPurchase_Date as datetime) + cast(Fuel_TOD as datetime) as Fuel_DT&#xa;    from #TempFuelPurchase&#xa;), dataY as (&#xa;    select *,&#xa;        lag(Fuel_DT, 1, dateadd(day, -1, Fuel_DT)) over (partition by Account_Number order by Fuel_DT) as last_DT&#xa;    from dataX&#xa;), dataZ as (&#xa;    select *,&#xa;        sum(&#xa;            case when datediff(second, last_DT, Fuel_DT) &gt; 3600 then 1 end&#xa;           ) over (partition by Account_Number order by Fuel_DT) as grp&#xa;    from dataY&#xa;)&#xa;select Account_Number, FuelPurchase_Date, Fuel_TOD,&#xa;    row_number() over (partition by Account_Number, grp order by Fuel_DT) as Seq&#xa;from dataZ" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="0.0263071" StatementEstRows="15" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x65AA3C60D5334D5E" QueryPlanHash="0x9E6C7CB80A0A557F" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="130"><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="88" CompileTime="0" CompileCPU="0" CompileMemory="528"><MemoryGrantInfo SerialRequiredMemory="640" SerialDesiredMemory="704" RequiredMemory="640" DesiredMemory="704" RequestedMemory="1024" GrantWaitTime="0" GrantedMemory="1024" MaxUsedMemory="24" MaxQueryMemory="194576"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="650288"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-04-24T23:33:29.53" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000001_BAB70385]" Table="[#TempFuelPurchase___________________________________________________________________________________________________0000000000C3]" Schema="[dbo]" Database="[tempdb]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.2e-006" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0263071" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="3e-007" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0263059" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference><ColumnReference Column="Segment1029"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1029"></ColumnReference></SegmentColumn><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="15" EstimateIO="0.0112613" EstimateCPU="0.000191452" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0263056" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="704" OutputMemoryGrant="512" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1007"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0148529" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1015]=(0) THEN NULL ELSE [Expr1016] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1015"></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="Expr1016"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-006" AvgRowSize="51" EstimatedTotalSubtreeCost="0.0148514" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1015"></ColumnReference><ColumnReference Column="Expr1016"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1015"></ColumnReference><ScalarOperator ScalarString="COUNT_BIG(CASE WHEN datediff(second,[Expr1005],[Expr1003])&gt;(3600) THEN (1) ELSE NULL END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(3600)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1016"></ColumnReference><ScalarOperator ScalarString="SUM(CASE WHEN datediff(second,[Expr1005],[Expr1003])&gt;(3600) THEN (1) ELSE NULL END)"><Aggregate Distinct="0" AggType="SUM"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Intrinsic FunctionName="datediff"><ScalarOperator><Const ConstValue="(8)"></Const></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator><ScalarOperator><Const ConstValue="(3600)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1003])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1028"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="30" EstimateIO="0" EstimateCPU="3.297e-005" AvgRowSize="51" EstimatedTotalSubtreeCost="0.014842" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="WindowCount1028"></ColumnReference><ColumnReference Column="Segment1026"></ColumnReference><ColumnReference Column="Segment1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="30" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="6" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="0" AvgRowSize="51" EstimatedTotalSubtreeCost="0.0148053" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Segment1026"></ColumnReference><ColumnReference Column="Segment1027"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1027"></ColumnReference></SegmentColumn><RelOp NodeId="7" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-007" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0148053" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference><ColumnReference Column="Segment1026"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1026"></ColumnReference></SegmentColumn><RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="35" EstimatedTotalSubtreeCost="0.0148043" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Count1014]=(0) THEN [Expr1010] ELSE [LastValue1013] END"><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Count1014"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Then><Else><ScalarOperator><Identifier><ColumnReference Column="LastValue1013"></ColumnReference></Identifier></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="9" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-006" AvgRowSize="76" EstimatedTotalSubtreeCost="0.0148028" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="LastValue1013"></ColumnReference><ColumnReference Column="Count1014"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Count1014"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="LastValue1013"></ColumnReference><ScalarOperator ScalarString="LAST_VALUE([Expr1003])"><Aggregate Distinct="0" AggType="LAST_VALUE"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ScalarOperator ScalarString="ANY([tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1003])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1003"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="ANY([Expr1010])"><Aggregate Distinct="0" AggType="ANY"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Column="WindowCount1025"></ColumnReference></GroupBy><RelOp NodeId="10" PhysicalOp="Window Spool" LogicalOp="Window Spool" EstimateRows="30" EstimateIO="0" EstimateCPU="3.297e-005" AvgRowSize="76" EstimatedTotalSubtreeCost="0.0147934" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="WindowCount1025"></ColumnReference><ColumnReference Column="Segment1024"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="28" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><WindowSpool><RelOp NodeId="11" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="9.42e-007" AvgRowSize="76" EstimatedTotalSubtreeCost="0.0147567" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="TopRowNumber1018"></ColumnReference><ColumnReference Column="BottomRowNumber1019"></ColumnReference><ColumnReference Column="Segment1024"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1024"></ColumnReference></SegmentColumn><RelOp NodeId="12" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="68" EstimatedTotalSubtreeCost="0.0147557" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference><ColumnReference Column="TopRowNumber1018"></ColumnReference><ColumnReference Column="BottomRowNumber1019"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="TopRowNumber1018"></ColumnReference><ScalarOperator ScalarString="[RowNumber1017]-(1)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="BottomRowNumber1019"></ColumnReference><ScalarOperator ScalarString="[RowNumber1017]-(1)"><Arithmetic Operation="SUB"><ScalarOperator><Identifier><ColumnReference Column="RowNumber1017"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="13" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.2e-006" AvgRowSize="51" EstimatedTotalSubtreeCost="0.0147542" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="RowNumber1017"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="RowNumber1017"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="14" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="15" EstimateIO="0" EstimateCPU="3e-007" AvgRowSize="51" EstimatedTotalSubtreeCost="0.014753" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference><ColumnReference Column="Segment1023"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1023"></ColumnReference></SegmentColumn><RelOp NodeId="16" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="15" EstimateIO="0.0112613" EstimateCPU="0.000191464" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0147527" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.5"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="896" OutputMemoryGrant="320" UsedMemoryGrant="16"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Column="Expr1003"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="17" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="15" EstimateIO="0" EstimateCPU="1.5e-006" AvgRowSize="43" EstimatedTotalSubtreeCost="0.0033" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0)"><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0)"><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="dateadd(day,(-1),CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[FuelPurchase_Date],0)+CONVERT(datetime,[tempdb].[dbo].[#TempFuelPurchase].[Fuel_TOD],0))"><Intrinsic FunctionName="dateadd"><ScalarOperator><Const ConstValue="(4)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-1)"></Const></ScalarOperator><ScalarOperator><Arithmetic Operation="ADD"><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator><ScalarOperator><Convert DataType="datetime" Style="0" Implicit="0"><ScalarOperator><Identifier><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></Arithmetic></ScalarOperator></Intrinsic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="18" PhysicalOp="Table Scan" LogicalOp="Table Scan" EstimateRows="15" EstimatedRowsRead="15" EstimateIO="0.003125" EstimateCPU="0.0001735" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0032985" TableCardinality="15" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="15" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="1" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Account_Number"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="FuelPurchase_Date"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" Column="Fuel_TOD"></ColumnReference></DefinedValue></DefinedValues><Object Database="[tempdb]" Schema="[dbo]" Table="[#TempFuelPurchase]" IndexKind="Heap" Storage="RowStore"></Object></TableScan></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></ComputeScalar></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Segment></RelOp></Segment></RelOp></WindowSpool></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
Account_Number	FuelPurchase_Date	Fuel_TOD	Seq
19	2024-04-03	07:02:02.0000000	1
19	2024-04-03	07:02:41.0000000	2
19	2024-04-03	14:58:49.0000000	1
19	2024-04-03	19:58:49.0000000	1
19	2024-04-05	14:58:49.0000000	1
19	2024-04-05	14:59:31.0000000	2
19	2024-04-17	23:56:13.0000000	1
19	2024-04-18	00:15:13.0000000	2
19	2024-04-18	14:56:13.0000000	1
19	2024-04-19	07:41:55.0000000	1
19	2024-04-19	07:42:20.0000000	2
20	2024-04-17	23:59:13.0000000	1
20	2024-04-18	07:41:55.0000000	1
20	2024-04-18	19:41:55.0000000	1
20	2024-04-18	19:56:55.0000000	2