Pivot Cross Join/Apply Query, Sql Server

Language: Layout:

IF OBJECT_ID('dbo.cte', 'U') IS NOT NULL 
  DROP TABLE dbo.budgets;

CREATE TABLE cte (
    Run_ID int, 
    Run_number int, 
    Notch int,
    Ptype varchar(50)
);

INSERT INTO cte VALUES (1, 1000723, 2, 'Break-in');
INSERT INTO cte VALUES (2, 1000723, 5, 'Break-in');
INSERT INTO cte VALUES (3, 1000723, 6, 'Break-in');
INSERT INTO cte VALUES (4, 1000723, 7, 'Break-in');
INSERT INTO cte VALUES (5, 1000723, 8, 'CCS');
INSERT INTO cte VALUES (6, 1000723, 8, 'Full-load');
INSERT INTO cte VALUES (7, 1000723, 8, 'Break-in');

SELECT * FROM cte;

SELECT s1.*, s2.*
FROM
(
SELECT t.[1] As [RunID_Notch1], 
       t.[2] As [RunID_Notch2], 
       t.[3] As [RunID_Notch3], 
       t.[4] As [RunID_Notch4], 
       t.[5] As [RunID_Notch5], 
       t.[6] As [RunID_Notch6], 
       t.[7] As [RunID_Notch7]

FROM (SELECT Run_ID, Notch FROM cte) c

PIVOT 
  (
    MAX(c.[Notch]) 
    FOR c.Run_ID IN ([1], [2], [3], [4], [5], [6], [7])
  ) AS t
) s1

CROSS APPLY
(
SELECT t.[1] As [RunID_Ptype1], 
       t.[2] As [RunID_Ptype2], 
       t.[3] As [RunID_Ptype3], 
       t.[4] As [RunID_Ptype4], 
       t.[5] As [RunID_Ptype5], 
       t.[6] As [RunID_Ptype6], 
       t.[7] As [RunID_Ptype7]

FROM (SELECT Run_ID, Ptype FROM cte) c

PIVOT 
  (
    MAX(c.[Ptype]) 
    FOR c.Run_ID IN ([1], [2], [3], [4], [5], [6], [7])
  ) AS t
) s2

View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 7, absolute service time: 0,19 sec