SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

(No column name)

Microsoft SQL Server 2022 (RTM-CU26) (KB5093420) - 16.0.4265.3 (X64) 
	Jul  7 2026 14:37:25 
	Copyright (C) 2022 Microsoft Corporation
	Express Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS) <X64>

-- GENERATE_SERIES arrived in SQL Server 2022
select value from generate_series(1, 5);

value

1

2

3

4

5

-- so did DATE_BUCKET and the WINDOW clause
select value
     , date_bucket(day, 2, dateadd(day, cast(value as int), cast('2026-01-01' as date))) as bucket
     , sum(value) over w as running
from generate_series(1, 5)
window w as (order by value);

value
bucket
running

1
2026-01-02
1

2
2026-01-02
3

3
2026-01-04
6

4
2026-01-04
10

5
2026-01-06
15

-- and IS [NOT] DISTINCT FROM, which treats two nulls as comparable
select iif(null is not distinct from null, 'equal', 'not equal') as nulls_compare;

nulls_compare

equal

value	bucket	running
1	2026-01-02	1
2	2026-01-02	3
3	2026-01-04	6
4	2026-01-04	10
5	2026-01-06	15