CREATE  TRIGGER TR_Update_EMRAppointmentDetails  
ON dbo.EMRAppointmentDetails  
FOR UPDATE  
AS  
if not ((substring(columns_updated(),1,8) & 255) = substring(columns_updated(),1,8) and (substring(columns_updated(),2,3) | 0) = 4)  
BEGIN  
            INSERT EMRAppointmentDetailsHistory  
            SELECT  
            APPOINTMENT_ID,PATIENT_ID,REFERED_BY,SPECIALTY_ID,REASON,CONSULTANT_ID,  
            APPOINTMENT_TYPE_ID,APPOINTMENT_DATE,APPOINTMENT_TIME,FRONTDESK_COMMENTS,  
            APPOINTMENT_STATUS_ID,CREATED_DATE,USER_LOGIN,VISIT_TYPE_ID,APPOINTMENT_LOCATION_ID,  
            HEALTH_PKG_ID,DISP_APPOINTMENT_ID,SRV_ITEM_ID,FULFILLED_APPOINTMENT_ID,
            FULFILLED_LOCATION_ID,FULFILLED_LOCATION,IS_LAB_APMT,TP_PKG_ID,TP_ITEM_ID,LAB_TEST_ID,
	    LAB_PROFILE_ID,LAST_UPDATED_DATE,LAST_UPDATED_USER,IS_TP_APPOINTMENT,BILL_NUMBER 
            FROM Deleted  
END
GO