UPDATE PH SET PH.IsActive = 0 FROM tbPaymentHeader PH
INNER JOIN QC_LocalWebCheckinDB.DBO.tbReservationDetails RD ON RD.ReservationNameID =PH.ReservationNameID
WHERE PH.IsActive = 1 AND DepartureDate < DATEADD(DAY,-1,DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0))