update Employee_Queue_Schedules set iActive_Flag = 0
  FROM Employee_Queue_Schedules 
    JOIN curResolvedAccts ON ...

>
>I'm trying to understand UPDATE FROM syntax and see, if I can apply it.
>
>Here is what I have
>

>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 ???
>

>
>I want to update all records in Employee_Queue_Schedules that have matching records in curResolvedAccts.