SQLize Online / PHPize Online  /  SQLtest Online

--Таблица юзеров With CTE_Users (userID,RegDate) AS (Select 1 as userID, CAST('20201101' as DATETIME) as RegDate Union ALL Select 2, CAST('20201201' as DATETIME)), --Таблица чисел CTE_Numbers (Number ) AS ( Select 0 AS Number UNION Select 1 UNION Select 2 UNION Select 3 UNION Select 4 UNION Select 5 UNION Select 6 UNION Select 7 UNION Select 8 UNION Select 9) --Тело запроса Select CTE_Users.userID, CTE_Users.RegDate, DateADD(DAY,tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number, CTE_Users.RegDate) NewDate from CTE_Users, CTE_Numbers AS tab_Numbers1, CTE_Numbers AS tab_Numbers2, CTE_Numbers AS tab_Numbers3, CTE_Numbers AS tab_Numbers4 Where DateADD(DAY,tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number, CTE_Users.RegDate) <= GETDATE () AND ((tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number) / 30) = (CAST(tab_Numbers1.Number as Decimal (15,3)) + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number)/30 Order By userID, NewDate