Updating large table take a long time.

Hi,

Please, rewrite your query as follows.

UPDATE PaymentSchedule SET Status = 2 WHERE PaymentScheduleID IN (SELECT ID FROM #FinalPayment)

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu