如何在工作日SQL Server的营业时间内计算两个日期之间的差值？

CREATE PROCEDURE CalculateWorkingDays
    @StartDate DATE,
    @EndDate DATE
AS
BEGIN
    -- 计算总天数
    DECLARE @TotalDays INT = DATEDIFF(day, @StartDate, @EndDate)

    -- 计算非工作日的天数
    DECLARE @Holidays INT
    SELECT @Holidays = COUNT(*) FROM HolidayTable WHERE HolidayDate BETWEEN @StartDate AND @EndDate

    -- 计算工作日的天数
    DECLARE @WorkingDays INT = @TotalDays - @Holidays

    -- 输出结果
    SELECT @WorkingDays AS WorkingDays
END

EXEC CalculateWorkingDays '2022-01-01', '2022-01-31'