CREATE TABLE #yourtable (grp int, Age int, Period int, Yr int) INSERT INTO #yourtable (grp, Age, Period, Yr) VALUES (1, 0 , NULL, NULL), (1, 1 , NULL, NULL), (1, 2 , NULL, NULL), (1, 3 , NULL, NULL), (1, 4 , NULL, NULL), (1, 5 , NULL, NULL), (1, 6 , NULL, NULL), (1, 7 , NULL, NULL), (1, 8 , NULL, NULL), (1, 9 , NULL, NULL), (1, 10, NULL, NULL), (1, 11, NULL, NULL), (1, 12, NULL, NULL), (1, 13, NULL, NULL), (1, 14, NULL, NULL), (1, 15, NULL, NULL), (1, 16, NULL, NULL), (1, 17, NULL, NULL), (1, 18, NULL, NULL), (1, 19, NULL, NULL), (1, 20, NULL, NULL), (1, 21, 2, 2021), (1, 22, NULL, NULL), (1, 23, NULL, NULL), (1, 24, NULL, NULL), (1, 25, NULL, NULL), (1, 26, null , null), (1, 27, NULL, NULL), (1, 28, NULL, NULL), (1, 29, NULL, NULL), (1, 30, NULL, NULL);

with cte as ( select age ,max(period - age) over () + age as period ,max(yr - age) over() + age as yr from #yourtable ) select age ,case when period >0 then period end as period ,yr from cte

; WITH PeriodInc AS (SELECT TOP 1 Period - Age AS PeriodInc FROM #yourtable WHERE Period IS NOT NULL), YrInc AS (SELECT TOP 1 Yr - Age AS YrInc FROM #yourtable WHERE Yr IS NOT NULL) SELECT Age, CASE WHEN (Age + PeriodInc) >= 0 THEN (Age + PeriodInc) ELSE NULL END AS Period, Age + YrInc AS Yr FROM #yourtable CROSS JOIN PeriodInc CROSS JOIN YrInc