Payroll: Update Value from one Def ID to another

From KeystoneIntranet
Revision as of 13:00, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Preview
select H.DEF_VALUE,
(select DEF_VALUE from prtempdefhst H2 where def_id='FEDGRS' AND H2.SESSION_NO=H.SESSION_NO
    AND H2.TRANS_NO=H.TRANS_NO),H.*
 from prtempdefhst H where def_id='LA_GROSS' 
AND H.DEF_VALUE<>(select DEF_VALUE from prtempdefhst H2 where def_id='FEDGRS' AND H2.SESSION_NO=H.SESSION_NO
    AND H2.TRANS_NO=H.TRANS_NO)
Update
update  prtempdefhst H  set
H.DEF_VALUE=(select DEF_VALUE from prtempdefhst H2 where def_id='FEDGRS' AND H2.SESSION_NO=H.SESSION_NO
    AND H2.TRANS_NO=H.TRANS_NO) 
where def_id='LA_GROSS' 
AND H.DEF_VALUE<>(select DEF_VALUE from prtempdefhst H2 where def_id='FEDGRS' AND H2.SESSION_NO=H.SESSION_NO
    AND H2.TRANS_NO=H.TRANS_NO)