Page Comparison

select SELECT 	pay.PIN,
	
       p01.Name,
       	persorg.name as               AS Organization,
       	pay.accountdim2 as            AS VesOrgID,
	isnull
       ISNULL(ves.name, 'N/A')    asAS 'Vessel Name',
	case when
       CASE 
            WHEN pay.ACCOUNTDIM3 isIS NULL orOR pay.ACCOUNTDIM3 = '' thenTHEN 'N/A'
		else
            ELSE pay.ACCOUNTDIM3
	end
       END 'Department',
	isnull
       ISNULL(CAT.NAME, 'Other')  asAS 'Category',
	Cast(Replace(Case when
       CAST(
           REPLACE(
               CASE 
                    WHEN pay.ENTRYFIELD2 = '' ThenTHEN '0' Else
                    ELSE pay.ENTRYFIELD2 End,
               END,
               ',',
               '.'
           ) as float) as 'Days/Quantity',
	Case When AS FLOAT
       )                          AS Days,
       CASE 
            WHEN pay.entryfield3 = '' ThenTHEN 0
		Else Round((
            ELSE ROUND(
                     (
                         dbo.ad_StrToFloat(
                             RIGHT(
                                 pay.entryfield3,
                                 LEN(pay.entryfield3) - PATINDEX('%[0-9]%', pay.entryfield3) + 1
                             )
                         )
                     ),
                     2
                 )
	End as 'Rate',
	pay.periodeused as Period,
	CONVERT(VARCHAR,
       END                        AS 'Daily Rate',
       pay.periodeused            AS Period,
       CONVERT(VARCHAR, PAY.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
	pay.calculatedamount1
       CASE 
            WHEN PAY.ENTRYCODE BETWEEN 30 AND 39 THEN pay.CALCULATEDAMOUNT10
            ELSE pay.CALCULATEDAMOUNT1
       END 'Amount',
      , 	pay.payscaletable as          AS 'PayScale Table',
       	pay.payscalecode as           AS 'PayScale Code',
       payscaleinfo.Table_Name 'PayScale Table Name',
       payscaleinfo.Payscale_Name 'PayScale Name',
	
       pay.rank as Rank,
	pay.currencyforpayment as                   AS RANK,
       pay.currencyforpayment     AS 'Payment Currency ',
       	pay.currencyrateforpayment 'Payment Currency Rate',
       	p01.client                    numorgid,
       	p01.employmentstartdate,
	
       p01.employmentenddate
FROM from  pw001pay pay
left join
       LEFT JOIN pw001p01 p01 on
            ON  p01.pin = pay.pin
left join
       LEFT JOIN pworg ves on
            ON  ves.numorgid = pay.accountdim2
left join
       LEFT JOIN pyety001 ec on
            ON  ec.entrycode = pay.entrycode
left join
       LEFT JOIN pworg persorg on
            ON  persorg.numorgid = p01.client
       leftLEFT joinJOIN PW001C117 CAT on
            ON  ec.CATEGORY = CAT.SEQUENCENO and
            AND pay.ENTRYCODE = ec.ENTRYCODE
                --left join pw001p03 p03 on p03.SEQUENCENO=pay.ACTIVITYSEQ
                --left join pw001c12 c12 on c12.CODE=p03.CODE
                --LEFT JOIN dbo.PWORG DEP ON DEP.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 4)
                --LEFT JOIN dbo.PWORG POS ON POS.NUMORGID = dbo.ad_scanorgtree(P03.NUMORGID, 5)
                
       LEFT JOIN (
                SELECT C0.REGULATIVECODE  AS 'Table_Code',
                       C0.REGULATIVENAME  AS 'Table_Name',
                       C1.PAYSCALECODE    AS 'Payscale_Code',
                       C1.PAYSCALENAME    AS 'Payscale_Name'
                FROM   PWPSC000 C0
                       LEFT JOIN PWPSC001 C1
                            ON  C1.SEQNO = C0.SEQNO
            ) payscaleinfo
            ON  payscaleinfo.Table_Code = pay.PAYSCALETABLE
            AND payscaleinfo.Payscale_Code = pay.PAYSCALECODE
WHERE  p01.CLIENT NOT IN (10012602)