SELECT IFNULL(MAX(Contact_ID),0)+1 As pContact_ID FROM #Request.prefix_db_agency#.pPtContacts UPDATE #Request.prefix_db_agency#.pPtContacts SET Status = , Record_Mod_date = , Record_Mod_By = WHERE Contact_ID = AND Patient_ID = INSERT INTO #Request.prefix_db_agency#.pPtContacts (Contact_ID, Patient_ID, Agency_ID, Status, First_Name, Last_Name, Pt_Realtionship, Emergency, Availability,Contact_Email, Location, Telephone1, Telephone2, M2102_CARE_TYPE_SRC_ADL, M2102_CARE_TYPE_SRC_MDCTN, M2102_CARE_TYPE_SRC_PRCDR, M2102_CARE_TYPE_SRC_SPRVSN, Notes, Record_Creation_Date, Record_Created_By, Record_Mod_date, Record_Mod_By ) VALUES ( , , , , , , , , , , , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pPtContacts WHERE Patient_ID = AND Emergency = AND status != SELECT * FROM #Request.prefix_db_agency#.pPatients WHERE Patient_ID = AND status NOT IN (2,3) SELECT * FROM #Request.prefix_db_agency#.pPtPayer WHERE Patient_ID =