您可以通过将数据转换为xml，然后使用cross-apply将其拆分来规范化数据。标准化后，使用stuff函数将日历代码组合成逗号分隔的列表。试试这个：

;WITH normalized_data as (
SELECT to_xml.productid
 ,split.split_calendarid 
FROM
     (
     SELECT *,
        cast('<X>'+replace(cs.calendarid,',','</X><X>')+'</X>' as XML) as xmlfilter
     FROM calendarschedule cs
     ) to_xml
 CROSS APPLY
     ( 
     SELECT new.D.value('.','varchar(50)') as split_calendarid 
     FROM to_xml.xmlfilter.nodes('X') as new(D)
     ) split
)   select distinct
        n.productid
        ,STUFF(
             (SELECT distinct ', ' + c.calendarCode
              FROM calendar c
              JOIN normalized_data n2 on n2.split_calendarid = c.calendarid
              WHERE n2.productid = n.productid
              FOR XML PATH ('')), 1, 1, '') calendarCode
    from normalized_data n

我觉得这个解决方案有点过于复杂了，但这是我让它工作的唯一方法。如果有人知道如何简化它，我很乐意听到一些反馈。