SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table jobevt
(
  num int,
  dat date,
  cls nvarchar(3),
  cde int
);


insert into jobevt (num, dat, cls, cde) values
(3177564, '2021-02-24', 'SYS',  10),
(3177564, '2021-02-24', 'SYS',  40),
(3177564, '2021-02-24', 'SYS',  40),
(3177564, '2021-02-24', 'SYS',  40),
(3177564, '2021-02-24', 'SYS',  42),
(3177564, '2021-02-24', 'SYS',  60),
(3177564, '2021-02-24', 'SYS',  60),
(3177564, '2021-02-24', 'SYS',  89),
(3177564, '2021-02-24', 'SYS', 100),
(3177564, '2021-02-24', 'SYS', 115),
(3177564, '2021-02-24', 'GEN', 120),
(3177564, '2021-03-01', 'GEN', 120),
(3177564, '2021-02-26', 'GEN', 160),
(3177564, '2021-02-24', 'SYS', 198),
(3177564, '2021-02-24', 'GEN', 210),
(3177564, '2021-02-26', 'GEN', 220),
(3177564, '2021-02-24', 'GEN', 310),
(3177564, '2021-02-26', 'GEN', 310),
(3177564, '2021-02-24', 'SYS', 422);

select * from jobevt;


num
dat
cls
cde


3177564
2021-02-24
SYS
10

3177564
2021-02-24
SYS
40

3177564
2021-02-24
SYS
40

3177564
2021-02-24
SYS
40

3177564
2021-02-24
SYS
42

3177564
2021-02-24
SYS
60

3177564
2021-02-24
SYS
60

3177564
2021-02-24
SYS
89

3177564
2021-02-24
SYS
100

3177564
2021-02-24
SYS
115

3177564
2021-02-24
GEN
120

3177564
2021-03-01
GEN
120

3177564
2021-02-26
GEN
160

3177564
2021-02-24
SYS
198

3177564
2021-02-24
GEN
210

3177564
2021-02-26
GEN
220

3177564
2021-02-24
GEN
310

3177564
2021-02-26
GEN
310

3177564
2021-02-24
SYS
422


-- question asker attempt

DECLARE @JobEventKey NVARCHAR(MAX) = ''
DECLARE @SQL NVARCHAR(MAX) = ''

SELECT @JobEventKey += QUOTENAME(cls + CAST(cde AS VARCHAR(10))) + ','
FROM jobevt

WHERE jobevt.num = '3177564'
--> num=3177564 contains multiple rows for "[SYS40]"
--> the contatenations contains duplicates!

SET @JobEventKey = LEFT(@JobEventKey, LEN(@JobEventKey) -1)

SET @SQL = 

'SELECT * FROM
    (SELECT
         num
        ,dat
        ,cde
        ,cls + CAST(cde AS VARCHAR(10)) --> 4th column missing an name / alias!
    FROM
        jobevt
    WHERE
        (num = 3177564)
) AS D

PIVOT (
    MAX(dat)
    FOR cde IN (' + @JobEventKey +
    ')
) AS P'

EXECUTE sp_executesql @SQL
Msg 8155 Level 16 State 2 Line 13
No column name was specified for column 4 of 'D'.
Msg 8156 Level 16 State 1 Line 16
The column 'SYS40' was specified multiple times for 'P'.

-- improved version

DECLARE @JobEventKey NVARCHAR(1000) = '';

SELECT @JobEventKey += QUOTENAME(je.cls + CONVERT(NVARCHAR(10), je.cde)) + ','
FROM jobevt je
WHERE je.num = 3177564
group by QUOTENAME(je.cls + CONVERT(NVARCHAR(10), je.cde))
order by QUOTENAME(je.cls + CONVERT(NVARCHAR(10), je.cde));

SET @JobEventKey = LEFT(@JobEventKey, LEN(@JobEventKey)-1);

-- validate keys
select @JobEventKey;

DECLARE @sql NVARCHAR(2000) = 
'SELECT P.*
 FROM ( SELECT je.num
              ,je.dat
              ,je.cls + CONVERT(NVARCHAR(10), cde) as clscde
        FROM jobevt je
        WHERE je.num = 3177564 ) AS d
 PIVOT (MAX(d.dat) FOR d.clscde IN (' + @JobEventKey + ')) AS P'

-- validate sql
select @sql;

-- execute
EXECUTE sp_executesql @sql;


(No column name)


[GEN120],[GEN160],[GEN210],[GEN220],[GEN310],[SYS10],[SYS100],[SYS115],[SYS198],[SYS40],[SYS42],[SYS422],[SYS60],[SYS89]




(No column name)


SELECT P.*
 FROM ( SELECT je.num
              ,je.dat
              ,je.cls + CONVERT(NVARCHAR(10), cde) as clscde
        FROM jobevt je
        WHERE je.num = 3177564 ) AS d
 PIVOT (MAX(d.dat) FOR d.clscde IN ([GEN120],[GEN160],[GEN210],[GEN220],[GEN310],[SYS10],[SYS100],[SYS115],[SYS198],[SYS40],[SYS42],[SYS422],[SYS60],[SYS89])) AS P




num
GEN120
GEN160
GEN210
GEN220
GEN310
SYS10
SYS100
SYS115
SYS198
SYS40
SYS42
SYS422
SYS60
SYS89


3177564
2021-03-01
2021-02-26
2021-02-24
2021-02-26
2021-02-26
2021-02-24
2021-02-24
2021-02-24
2021-02-24
2021-02-24
2021-02-24
2021-02-24
2021-02-24
2021-02-24

num	dat	cls	cde
3177564	2021-02-24	SYS	10
3177564	2021-02-24	SYS	40
3177564	2021-02-24	SYS	40
3177564	2021-02-24	SYS	40
3177564	2021-02-24	SYS	42
3177564	2021-02-24	SYS	60
3177564	2021-02-24	SYS	60
3177564	2021-02-24	SYS	89
3177564	2021-02-24	SYS	100
3177564	2021-02-24	SYS	115
3177564	2021-02-24	GEN	120
3177564	2021-03-01	GEN	120
3177564	2021-02-26	GEN	160
3177564	2021-02-24	SYS	198
3177564	2021-02-24	GEN	210
3177564	2021-02-26	GEN	220
3177564	2021-02-24	GEN	310
3177564	2021-02-26	GEN	310
3177564	2021-02-24	SYS	422