comma join, Sql Server

Language: Layout:

CREATE TABLE TReferensi
    ([IdReferensi] int, [Referensi] varchar(6))
;

INSERT INTO TReferensi
    ([IdReferensi], [Referensi])
VALUES
    (1, 'Alfa'),
    (2, 'Beta'),
    (3, 'Carlie'),
    (4, 'Delta')
;

CREATE TABLE TCPAR
    ([IdCPAR] int, [IdReferensi] varchar(100))
;
    
INSERT INTO TCPAR
    ([IdCPAR], [IdReferensi])
VALUES
    (1, '''1'',''2'''),
    (2, '''1'',''3'',''4''')
;

;with cte as
(
    select
        t1.IdCPAR, t2.IdReferensi
    from
    (
        select
            IdCPAR, 
            IdReferensi = cast(cast(t2.c.query('data(.)') as varchar) as int)
        from
        (
            select 
                IdCPAR,
                ReferensiXml = cast('<root><a>' + replace(REPLACE(IdReferensi,'''',''), ',', '</a><a>') + '</a></root>' as xml)
            from TCPAR
        ) t1
        cross apply ReferensiXml.nodes('/root/a') t2(c)
    ) t1
    join TReferensi t2 on t1.IdReferensi = t2.IdReferensi
)

SELECT T2.IdCPAR,T3.IdReferensi,
        STUFF((SELECT ','''+Referensi+''''
        FROM (
                select 
                    t1.IdCPAR,t2.Referensi
                from cte t1
                INNER JOIN TReferensi t2 
                ON  t2.IdReferensi = t1.IdReferensi 
             )T1
        WHERE T2.IdCPAR = T1.IdCPAR
        FOR XML PATH('')),1,1,'') AS Referensi
FROM(
    select 
        t1.IdCPAR,t2.Referensi
    from cte t1
    INNER JOIN TReferensi t2 
    ON  t2.IdReferensi = t1.IdReferensi 
 )T2
INNER JOIN TCPAR T3
 ON T3.IdCPAR = T2.IdCPAR
GROUP BY T2.IdCPAR,T3.IdReferensi

View schema
Execution time: 0,08 sec, rows selected: 2, rows affected: 6, absolute service time: 0,23 sec