Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-216446 - Restricted Chemical rules|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-216446]
1. Convert Restricted Chemical Yes
2. Convert EPA number
select distinct(agitm_no) from agitmmst
where agitm_rest_chem_rpt_yn = 'Y'
select ysnRestrictedChemical, * from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_rest_chem_rpt_yn = 'Y'
begin tran
update tblICItem
set ysnRestrictedChemical = 1
from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_rest_chem_rpt_yn = 'Y'
commit tran
End Goal:
!pastedImage_d104076_0.png!
!pastedImage_d104076_1.png!
select ysnRestrictedChemical, agitm_rest_chem_rpt_yn, strEPANumber, agitm_epa_no, * from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_rest_chem_rpt_yn = 'Y'
begin tran
update tblICItem
set strEPANumber = agitm_epa_no
from tblICItem
inner join agitmmst on tblICItem.strItemNo = agitmmst.agitm_no collate SQL_Latin1_General_CP1_CS_AS
where agitm_rest_chem_rpt_yn = 'Y'
|