如何使用CURSOR/PROC在SQL中计算两个不同日期之间的工作小时数？

CREATE PROCEDURE CalculateWorkingHours
    @StartDate DATE,
    @EndDate DATE
AS
BEGIN
    -- 声明变量
    DECLARE @CurrentDate DATE
    DECLARE @WorkingHours INT

    -- 初始化变量
    SET @CurrentDate = @StartDate
    SET @WorkingHours = 0

    -- 创建游标
    DECLARE @Cursor CURSOR
    SET @Cursor = CURSOR FOR
        SELECT DateValue
        FROM CalendarTable
        WHERE DateValue >= @StartDate AND DateValue <= @EndDate

    -- 遍历游标
    OPEN @Cursor
    FETCH NEXT FROM @Cursor INTO @CurrentDate

    WHILE @@FETCH_STATUS = 0
    BEGIN
        -- 检查当前日期是否为工作日
        IF dbo.IsWorkingDay(@CurrentDate) = 1
        BEGIN
            -- 增加工作小时数
            SET @WorkingHours = @WorkingHours + dbo.GetWorkingHours(@CurrentDate)
        END

        FETCH NEXT FROM @Cursor INTO @CurrentDate
    END

    -- 关闭游标
    CLOSE @Cursor
    DEALLOCATE @Cursor

    -- 返回工作小时数
    SELECT @WorkingHours AS WorkingHours
END