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