By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT 1 AS logcount, 1 AS logUserId, GETDATE() - 130 AS maxlogtm
INTO statslogsummary
UNION ALL
SELECT 2 AS logcount, 2 AS logUserId, GETDATE() - 150 AS maxlogtm
2 rows affected
SELECT *
FROM statslogsummary
| logcount | logUserId | maxlogtm |
|---|---|---|
| 1 | 1 | 15/10/2019 17:16:03 |
| 2 | 2 | 25/09/2019 17:16:03 |
SELECT logcount, logUserID, maxlogtm, c.daysdiff
FROM statslogsummary s
CROSS APPLY (SELECT DATEDIFF(day, s.maxlogtm, GETDATE()) AS daysdiff) c
WHERE c.daysdiff > 120
| logcount | logUserID | maxlogtm | daysdiff |
|---|---|---|---|
| 1 | 1 | 15/10/2019 17:16:03 | 130 |
| 2 | 2 | 25/09/2019 17:16:03 | 150 |