MSSQL Pivot to be used in a View, Sql Server

Language: Layout:

CREATE TABLE Vw_Beta_CostLog(
   GUID      VARCHAR(7) NOT NULL
  ,EmpName   VARCHAR(40) NOT NULL
  ,RefNumber INTEGER  NOT NULL
  ,DateInt   DATE  NOT NULL
  ,Hours     INTEGER 
  ,WorkType  VARCHAR(18) NOT NULL
  ,ProductID VARCHAR(12)
  ,PQty      INTEGER 
);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3468','Gary Hahn',114204,'20181008',132,'Painting',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3473','Gary Hahn',114204,'20181009',204,'Painting',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3475','Gary Hahn',114204,'20181009',120,'Painting',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-31915','Jose Flores',114204,'20181007',60,'Handling: Raw',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-31941','Jose Flores',114204,'20181008',30,'Handling: Raw',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-31951','Chris Pollock',114204,'20181008',30,'Handling: Raw',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-32076','Chris Pollock',114204,'20181010',120,'Handling: Product',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-32109','Chris Pollock',114204,'20181011',90,'Handling: Product',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('F-32301','Daryl Underwood',114204,'20181015',15,'Handling: Product',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('B-6594','David Martinez',114204,'20181007',150,'Blast',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('B-6599','Emiliano Barrios',114204,'20181008',66,'Blast',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('B-6617','Jose Molina',114204,'20181009',30,'Blast',NULL,NULL);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3468','Gary Hahn',114204,'20181008',NULL,'Primer','11',3);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3473','Gary Hahn',114204,'20181009',NULL,'Intermediate','890',2);
INSERT INTO Vw_Beta_CostLog(GUID,EmpName,RefNumber,DateInt,Hours,WorkType,ProductID,PQty) VALUES ('P-3475','Gary Hahn',114204,'20181009',NULL,'Finish','134HG',2);

--https://stackoverflow.com/questions/53014498/sql-pivot-to-be-used-in-a-view/

SELECT
    RefNumber
    , SUM (CASE WHEN WorkType = 'Blast'             THEN Hours/60 ELSE NULL END) AS TBlast
    , SUM (CASE WHEN WorkType = 'Wheel'             THEN Hours/60 ELSE NULL End) As TWheel
    , SUM (CASE WHEN WorkType = 'Painting'          THEN Hours/60 ELSE NULL END) AS TPainter
    , SUM (CASE WHEN WorkType = 'Mask/Prep'         THEN Hours/60 ELSE NULL END) As TMask
    , SUM (CASE WHEN WorkType = 'Demask/Touch Up'   THEN Hours/60 ELSE NULL END) As TDMask
    , SUM (CASE WHEN WorkType = 'Handling: Raw'     THEN Hours/60 ELSE NULL END) As TRHand
    , SUM (CASE WHEN WorkType = 'Handling: Product' THEN Hours/60 ELSE NULL END) As TPHand
    , SUM (CASE WHEN WorkType = 'Wheel:Assist'      THEN Hours/60 ELSE NULL END) As TAWheel
    , SUM (CASE WHEN WorkType = 'Metalizing'        THEN Hours/60 ELSE NULL END) As TMetal
    , MAX (CASE WHEN rn = 1 THEN WorkType END)  As WorkType1
    , MAX (CASE WHEN rn = 1 THEN ProductID END) As Product1
    , MAX (CASE WHEN rn = 1 THEN PQty END)      As Qty1
    
    , MAX (CASE WHEN rn = 2 THEN WorkType END)  As WorkType2
    , MAX (CASE WHEN rn = 2 THEN ProductID END) As Product2
    , MAX (CASE WHEN rn = 2 THEN PQty END)      As Qty2
    
    , MAX (CASE WHEN rn = 3 THEN WorkType END)  As WorkType3
    , MAX (CASE WHEN rn = 3 THEN ProductID END) As Product3
    , MAX (CASE WHEN rn = 3 THEN PQty END)      As Qty3
FROM (
    SELECT
        [RefNumber]
      , [WorkType]
      , [ProductID]
      , Hours
      , PQty
      , ROW_NUMBER() OVER (PARTITION BY RefNumber, case when ProductID IS NULL then 0 else 1 end ORDER BY ProductID) rn
    FROM [Vw_Beta_CostLog]
) sub
GROUP BY
    RefNumber
ORDER BY
    RefNumber
;

SELECT
        [RefNumber]
      , [WorkType]
      , [ProductID]
      , Hours
      , PQty
      , ROW_NUMBER() OVER (PARTITION BY RefNumber, case when ProductID IS NULL then 0 else 1 end ORDER BY ProductID) rn
    FROM [Vw_Beta_CostLog]
;

View schema
Execution time: 0,03 sec, rows selected: 16, rows affected: 15, absolute service time: 0,22 sec