mssql 表 shengri 中：
birthday 为公历生日，例如 2000-2-29
nongli 为农历生日，例如 2000-1-25
gongnong 为生日类型，例如 0 表示过公历生日（birthday），1 表示过农历生日（nongli）。

已知条件：今日公历为 2023-11-26，农历为 2023-10-14，请帮忙查询 未来 14天内过生日的列表。
要求考虑：
1、平年 2月29 改为 2月 28 生日，闰年继续使用 2-29
2、注意 12 月底过后 1月份的年份是明年

DECLARE @today DATE = '2023-11-26';
DECLARE @nongli DATE = '2023-10-14';

WITH Birthdays AS (
  SELECT
    *,
    DATEFROMPARTS(YEAR(@today), MONTH(birthday), CASE WHEN MONTH(birthday) = 2 AND DAY(birthday) = 29 AND NOT (YEAR(@today) % 4 = 0 AND (YEAR(@today) % 100 <> 0 OR YEAR(@today) % 400 = 0)) THEN 28 ELSE DAY(birthday) END) AS next_birthday_gongli,
    DATEDIFF(DAY, @today, DATEFROMPARTS(YEAR(@today), MONTH(birthday), CASE WHEN MONTH(birthday) = 2 AND DAY(birthday) = 29 AND NOT (YEAR(@today) % 4 = 0 AND (YEAR(@today) % 100 <> 0 OR YEAR(@today) % 400 = 0)) THEN 28 ELSE DAY(birthday) END)) AS days_to_next_birthday_gongli,
    DATEDIFF(DAY, @nongli, DATEFROMPARTS(YEAR(@today), MONTH(birthday), CASE WHEN MONTH(birthday) = 2 AND DAY(birthday) = 29 AND NOT (YEAR(@today) % 4 = 0 AND (YEAR(@today) % 100 <> 0 OR YEAR(@today) % 400 = 0)) THEN 28 ELSE DAY(birthday) END)) AS days_to_next_birthday_nongli
  FROM shengri
  WHERE gongnong = 0 OR (gongnong = 1 AND MONTH(@nongli) <= 9 AND MONTH(birthday) <= 9) OR (gongnong = 1 AND MONTH(@nongli) > 9 AND MONTH(birthday) > 9)
)
SELECT *
FROM Birthdays
WHERE days_to_next_birthday_gongli >= 0 AND days_to_next_birthday_gongli <= 14
ORDER BY days_to_next_birthday_gongli ASC;

-- 得到 14 天内生日的人
select * from (
    -- 计算离生日还有多少天
    select gongnong, today, birthday, datediff(day, today, birthday) remain from (
        -- 如果生日已经过了，改为明年对比
        select cast(case when birthday<today then dateadd(year, 1, birthday) else birthday end as date) birthday, today, gongnong from (
            -- 替换农历的 2-29, 2-30 为 2-28，防止出错
            select toyear + '-' + case when birthday in ('2-29', '2-30') then '2-28' else birthday end birthday, gongnong, today from(
                -- 取 mm-dd
                select gongnong, today, toyear, substring(cast(birthday as varchar), 6, 5) birthday from(
                    -- 取今天和生日日期
                    select cast(year(getdate()) as varchar) toyear, gongnong,
                    case gongnong when 0 then cast(getdate() as date) else '2023-10-15' end today,
                    case gongnong when 0 then birthday else nongli end birthday
                    from shengri where [user]=1
                ) a
            ) a
        ) a
    ) a
) a where a.remain<15

sql = "select count(0) from (select gongnong, today, birthday, datediff(day, today, birthday) remain from (select cast(case when birthday<today then dateadd(year, 1, birthday) else birthday end as date) birthday, today, gongnong from (select toyear + '-' + case when birthday in ('2-29', '2-30') then '2-28' else birthday end birthday, gongnong, today from(select gongnong, today, toyear, substring(cast(birthday as varchar), 6, 5) birthday from(select cast(year(getdate()) as varchar) toyear, gongnong, case gongnong when 0 then cast(getdate() as date) else '"& jinnongli &"' end today, case gongnong when 0 then birthday else nongli end birthday from shengri where [user]="&session("user")&") a) a) a) a) a where a.remain<15"