SELECT 
abbreviatedname AS FE, 
[NKH] AS NKH,
[AJF] AS AJF,
[CPM] AS CPM,
[HGH] AS HGH,
[REJ] AS REJ,
[PNH] AS PNH,
[ACJ] AS ACJ,
[BRC] AS BRC,
[CJM] AS CJM,
[HRG] AS HRG,
[CST] AS CST,
[SEK] AS SEK,
[GJS] AS GJS,
[JAW] AS JAW,
[RMB] AS RMB,
[BPH] AS BPH,
[JMB] AS JMB,
[CWM] AS CWM,
[DMC] AS DMC,
[DJW] AS DJW,
[GMP] AS GMP,
[MDN] AS MDN,
[JJC] AS JJC,
[SKT] AS SKT,
[ECO] AS ECO
FROM
(
SELECT e.abbreviatedname, n.namecode, w.totalunits
FROM WORKHISTORY AS w
INNER JOIN EMPLOYEE AS e ON w.EMPLOYEENO=e.EMPLOYEENO
INNER JOIN CASES AS c ON c.CASEID=w.CASEID
LEFT OUTER JOIN CASENAME AS cn ON cn.CASEID = c.CASEID AND cn.NAMETYPE IN ('SIG', 'SA')
LEFT OUTER JOIN NAME AS n ON n.NAMENO=cn.NAMENO
LEFT OUTER JOIN CASENAME AS fe ON fe.CASEID = c.CASEID AND fe.NAMETYPE = 'EMP'
LEFT OUTER JOIN NAME AS n3 ON n3.NAMENO=fe.NAMENO
WHERE w.TRANSTYPE=400 AND w.TRANSDATE>=DATEADD(DAY,-180 ,GETDATE())
AND w.WIPCODE NOT IN ('ZPA', 'ZPD', 'ZERO')) i
PIVOT
(
SUM(totalunits)
FOR namecode IN
([NKH], [AJF], [CPM], [HGH], [REJ], [PNH], [ACJ], [BRC], [CJM], [HRG], [CST], [SEK], [GJS], 
[JAW], [RMB], [BPH], [JMB], [CWM], [DMC], [DJW], [GMP], [MDN], [JJC], [SKT], [ECO])
) AS pvt
ORDER BY pvt.abbreviatedname