Activity overview
Latest activity by JustinBBBB
SQL Server 2022 Select - Window Clause with multiple window definitions stops code suggestions
Here is an example:
;With cte1 as (
Select tn.value, tn.value + 1 AS valPlus1 from generate_series(0,100,1) tn
), cte2 AS (
SELECT
c.[value],
SUM(c.[value]) OVER lastTenWin AS last10Sum
...