Как поместить в столбец значения из ячейки?

DECLARE @TTT TABLE (employee VARCHAR(50), act VARCHAR(100), id VARCHAR(250))
 
INSERT INTO @TTT (employee, act, id)
    VALUES('Инспектор','3.2.2.; 3.2.3.', 'IR4R54153; IR4RR99R8'),
        ('Начальник','3.2.1.; 3.2.2.; 3.2.3.', 'I35RRR34429; IR4R54153; IR4RR99R8'),
        ('Начальник сектора', '3.2.4.1.;', 'IR5112168; IR4R117R626; IR5713465; IR4R5364R'),
        ('Начальник отдела', '3.2.5.1.;', 'I31RR4218; IR5713465; I17998712; I17R3R713; IR5715631; IR8R72315; I16RR1645R9; I34R6428271; IR4R1R798'),
        ('Строитель', '3.2.9.1.1.;', 'IR5112168; IR4R117R626; I17RRR33482; I41RRRRR61R; I31RR4218; IR5713465; IR4R5364R; I17R4R863; I17998374; I17998712; I18RRR82719; I18R28643; I34R1515869; 2462222R19'),
        ('Менеджер', '3.2.9.2.1.;', 'IR4R24328; I17R33R5783; I44RRRR3972'),
        ('Начальник УРПЗ', '3.2.9.2.3.;', 'IR4R24328; I17R33R5783; I44RRRR3972')
 
 
;WITH cteEmployee (employee, act, id, etalon, level)
AS
(
SELECT employee, act, 
    SUBSTRING(REPLACE(id,' ',''),1,CASE WHEN PATINDEX ( '%;%' , id )<>0 THEN PATINDEX ( '%;%' , id ) ELSE LEN(id) END) AS id, 
    SUBSTRING(REPLACE(id,' ',''),PATINDEX ( '%;%' , id )+1, LEN(id)) AS etalon,
    0 AS level 
FROM @TTT
UNION ALL
SELECT A.employee, A.act, 
        SUBSTRING(CTE.etalon,1,CASE WHEN PATINDEX ( '%;%' , CTE.etalon )<>0 THEN PATINDEX ( '%;%' , CTE.etalon ) ELSE LEN(CTE.etalon) END) AS id,  
        CASE WHEN PATINDEX ( '%;%' , CTE.etalon )>0 THEN SUBSTRING(CTE.etalon,PATINDEX ( '%;%' , CTE.etalon )+1, LEN(CTE.etalon)) ELSE '' END AS etalon,
        CTE.level+1 AS level 
FROM @TTT A
INNER JOIN cteEmployee CTE ON A.employee = CTE.employee AND len(CTE.etalon)>0
)
SELECT employee, act, id
FROM cteEmployee
ORDER BY employee, level