>>>

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

>>Thanks a lot. While I was waiting your reply <g> I used where cPK in (select ..) syntax, which I assume is slower. Correct?
>
>Usually JOIN is faster in SELECTs but I'm not sure about UPDATEs.

Would this work:

update myTable set myField = mycursor.myField from myTable inner join myCursor on

??