如果将标签转换为按customerID和serviceCode分组的数据列，则可以使用两个中间结果解决此问题-一个用于按CustomerID和ServiceCode分组的金额，另一个用于按CustomerID和ServiceCode分组的标签。使用标签，您还需要将值的“列”转换为值的“列表”。这是一个已经被问过很多次的问题。有不止一个解决方案，如果你有更新版本的SQL Server，可能会有更好的解决方案。请看这篇文章：how-to-turn-one-column-of-a-table-into-a-csv-string-in-sql-server-without-using
下面是一个适合您的情况的示例，但肯定需要更多数据进行测试，以确保考虑到所有情况。我认为，不用说，您应该规范化数据，并且不使用Label_One、Label_Two、Label_Three等字段，这样我们就不需要长union查询来将所有标签放在一起。

-- -------------------------------------------------
-- Some Test Data
declare @Temp table (
    CustomerID int,
    ServiceCode int,
    Amount decimal(9, 2),
    Label_One nvarchar(30),
    Label_Two nvarchar(30),
    Label_Three nvarchar(30),
    Label_Four nvarchar(30)
);
insert into @Temp values
    (123456, 1066, 123.66, 'HY', 'CFD', null, null),
    (123456, 1066, 0.00, null, null, null, null)
-- -------------------------------------------------
-- -------------------------------------------------

-- Two CTEs representing the amounts by service code and customer,
-- and the labels by service code and customer
-- (think of these as two temp tables if you are not familiar with CTEs)
;with amounts as (
    select
        CustomerID,
        ServiceCode,
        sum(Amount) TotalAmount
    from
        @Temp
    group by
        CustomerID,
        ServiceCode
),
labels as (
    select
        CustomerID,
        ServiceCode,
        Label_One as [Label]
    from @Temp
    union all
    select
        CustomerID,
        ServiceCode,
        Label_Two as [Label]
    from @Temp
    union all
    select
        CustomerID,
        ServiceCode,
        Label_Three as [Label]
    from @Temp
    union all
    select
        CustomerID,
        ServiceCode,
        Label_Four as [Label]
    from @Temp)

-- join the two CTEs on service code and customer,
-- with a "column to csv list" strategy for the labels.
select 
    amounts.CustomerID,
    amounts.ServiceCode,
    substring(
        (select ',' + labels.[Label]
        from labels labels
        where labels.CustomerID = amounts.CustomerID
            and labels.ServiceCode = amounts.ServiceCode
        order by labels.[Label]
        for xml path('')),2,200000
    ) as CSVList,
    amounts.TotalAmount
from 
    amounts;