update tbl_TPM_Claims set archived = 'Y', archiveDate = where ownerId = and ownerType = and createDate < and archived = 'N' and claimStatus in ( 'APPROVED', 'DENIED' )

#_r.recordCount# claims prior to #lsdateformat( _archiveBeforeDate )# archived at #_archiveDate#.

UPDATE clm SET clm.archived = 'Y' ,clm.archiveDate = FROM tbl_TPM_Claims AS clm INNER JOIN tbl_TPM_ClaimStatusReasons AS rsn ON clm.ownerType = rsn.ownerType AND clm.ownerId = rsn.ownerId AND clm.statusReasonId = rsn.reasonId WHERE clm.ownerType = AND clm.ownerId = AND clm.claimStatus = 'HOLD' AND clm.archived = 'N' AND rsn.reasonName = 'EDI Suppression'