UPDATE #Request.prefix_db_agency#.Email_Daily_QA SET status = 1 WHERE status = 0 AND Header IN ('caregiver_alerts', 'caregiver alerts') UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1 WHERE status = 0 AND Header IN ('caregiver_alerts', 'caregiver alerts') AND Emp_ID = INSERT INTO #Request.prefix_db_agency#.Email_Daily_QA (Daily_QA_Date, Assmt_ID, Emp_ID, Patient_ID, Pt_Last, Pt_First, Emp_First, Emp_Last, Header, Description, Created_Date, status) VALUES ( , , , , , , , , , , , ) INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , ) INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , )