Page Comparison

select SELECT 	pyh.PIN,
	
       p01.Name,
       	persorg.name as               AS Organization,
       	pyh.accountdim2 as            AS VesOrgID,
	isnull
       ISNULL(ves.name, 'N/A')    asAS 'Vessel Name',
	case when       CASE 
            WHEN pyh.ACCOUNTDIM3 isIS NULL orOR pyh.ACCOUNTDIM3 = '' thenTHEN 'N/A'
		else
            ELSE pyh.ACCOUNTDIM3
	end
       END 'Department',
	isnull
       ISNULL(CAT.NAME, 'Other') as AS 'Category',
	Cast(Replace(Case when
       CAST(
           REPLACE(
               CASE 
                    WHEN pyh.ENTRYFIELD2 = '' ThenTHEN '0' Else
                    ELSE pyh.ENTRYFIELD2 End,
               END,
               ',',
               '.'
           ) as float) as Days,
	Case When AS FLOAT
       )                          AS Days,
       CASE 
            WHEN pyh.entryfield3 = '' ThenTHEN 0
		Else Round((
            ELSE ROUND(
                     (
                         dbo.ad_StrToFloat(
                             RIGHT(
                                 pyh.entryfield3,
                                 LEN(pyh.entryfield3) - PATINDEX('%[0-9]%', pyh.entryfield3) + 1
                             )
                         )
                     ),
                     2)
	End as
                 )
       END                        AS 'Daily Rate',
       	pyh.periodeused as            AS Period,
	
       CONVERT(VARCHAR, pyh.ENTRYCODE) + ' ' + EC.TEXT AS 'Entry Code',
	pyh.calculatedamount1
       CASE 
            WHEN pyh.ENTRYCODE BETWEEN 30 AND 39 THEN pyh.CALCULATEDAMOUNT10
            ELSE pyh.CALCULATEDAMOUNT1
       END 'Amount' ,
	,
       pyh.payscaletable as          AS 'Pay Scale Table',
       	pyh.payscalecode as           AS 'Pay Scale Code',
       payscaleinfo.Table_Name 'PayScale Table Name',
       payscaleinfo.Payscale_Name 'PayScale Name',
       	pyh.rank as Rank,
	pyh.currencyforpayment as                   AS RANK,
       pyh.currencyforpayment     AS 'Currency for Payment',
	       pyh.currencyrateforpayment 'Currency Rate for Payment',
	
       p01.client                    numorgid,
	       p01.employmentstartdate,
	       p01.employmentenddate
FROM from  pw001pyh pyh
left join
       LEFT JOIN pw001p01 p01 on
            ON  p01.pin = pyh.pin
left join
       LEFT JOIN pworg ves on
            ON  ves.numorgid = pyh.accountdim2
left join
       LEFT JOIN pyety001 ec on
            ON  ec.entrycode = pyh.entrycode
left join       LEFT JOIN pworg persorg on
            ON  persorg.numorgid = p01.client
left join       LEFT JOIN PW001C117 CAT on
            ON  ec.CATEGORY = CAT.SEQUENCENO and
            AND pyh.ENTRYCODE = ec.ENTRYCODE
                --left join pw001p03 p03 on p03.SEQUENCENO=pyh.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 = pyh.PAYSCALETABLE
            AND payscaleinfo.Payscale_Code = pyh.PAYSCALECODE