这里有两个解决方案可以让你接近。
样本数据：

DECLARE @data TABLE
(
    BranchCode NVARCHAR(100)
    ,WeekDay NVARCHAR(100)
    ,OpenTime NVARCHAR(100)
    ,CloseTime NVARCHAR(100)
)

INSERT INTO @data
VALUES
('1001.0000', 'Friday', '06:00', '21:00')
,('1001.0000', 'Monday', '06:00', '21:00')
,('1001.0000', 'Saturday', NULL, NULL)
,('1001.0000', 'Sunday', NULL, NULL)
,('1001.0000', 'Thursday', '08:00', '17:00')
,('1001.0000', 'Tuesday', '08:00', '17:00')
,('1001.0000', 'Wednesday', '08:00', '17:00')

第一种方法更像是一种动态的方法，但与预期结果有点偏差，但需要的代码更少。

select BranchCode,
    (SELECT 
        WeekDay
        ,OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode
     FOR JSON PATH
     ) as [HoursOfOperation]
FROM @data dOuter
FOR JSON PATH, INCLUDE_NULL_VALUES, ROOT('Branches')

第二种方法的动态性较差，但更接近您的示例。因为sql使用表名作为元素名，所以很难为每个分支提供一个命名元素。我们可以在工作日这样做，因为它们是已知常数。因此，实际上，您只需要得到一个具有分支代码属性和操作时间的分支对象数组。样本数据也可用于此解决方案。

select DISTINCT BranchCode,
    (SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Sunday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Sunday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Monday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Monday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Tuesday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Tuesday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Wednesday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Wednesday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Thursday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Thursday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Friday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Friday]
     ,(SELECT
        OpenTime
        ,CloseTime
     FROM @data dInner
     WHERE dInner.BranchCode = dOuter.BranchCode and dInner.[WeekDay] = 'Saturday'
     FOR JSON PATH, INCLUDE_NULL_VALUES
     ) as [HoursOfOperation.Saturday]
FROM @data dOuter
FOR JSON PATH, INCLUDE_NULL_VALUES, ROOT('Branches')