...
SELECT
P.PIN,
1 AS COUNT,
P.NAME,
PAY.PERIODEUSED as 'PERIOD',
PAY.ENTRYCODE 'EC NUMBER',
CONVERT(VARCHAR,pay.ENTRYCODE)+' '+EC.TEXT AS 'ENTRY CODE',
PAY.CALCULATEDAMOUNT1 AS AMOUNT,
PAY.CALCULATEDAMOUNT2 as 'EMPLOYERS FEE',
PAY.CALCULATEDAMOUNT3 as 'LEAVE PAY',
PAY.CALCULATEDAMOUNT4 as 'EMP. FEE LP',
PAY.CALCULATEDAMOUNT6 as 'PENSION FEE',
PAY.CURRENCYFORPAYMENT AS 'PAYMENT CURRENCY',
Pay.PAID,
PAY.DATE_OF_PAYMENT,
PAY.TEXT,
convert(float, case when entryfield2='' then '0' else replace(entryfield2, ',', '.') end) as QUANTITY,
ORG.NAME AS VESSEL,
P.CLIENT NUMORGID,
P.EMPLOYMENTSTARTDATE,
P.EMPLOYMENTENDDATE,
CMP.NAME as COMPANY,
EMP.NAME as EMPLOYER,
CURCMP.NAME as 'CURRENT COMPANY LINK'
...