>select cEmployee_Queue_Schedules_pk ; > from Trans inner join Trans_Employees_Queues TEQ ; > on Trans.cTrans_pk = TEQ.cTrans_fk ; > inner join Employee_Queue_Schedules EQS ; > on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ; > where not Trans.cResolution_Codes_fk is null ; > and EQS.iActive_Flag = 1 into cursor curResolvedAccts > > update Employee_Queue_Schedules set iActive_Flag = 0 ??? >>
update EQS set iActive_Flag = 0 ; from Trans inner join Trans_Employees_Queues TEQ ; on Trans.cTrans_pk = TEQ.cTrans_fk ; inner join Employee_Queue_Schedules EQS ; on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ; where Trans.cResolution_Codes_fk is not null ; and EQS.iActive_Flag = 1