SELECT pEmployee.Emp_ID, pEmployee.Emp_First, pEmployee.Emp_Last, pEmployee.Loc_ID, Agency.Agency_Login FROM hhapowerpath.pEmployee JOIN hhapowerpath.Agency ON Agency.Agency_ID = pEmployee.Loc_ID WHERE pEmployee.Username = AND pEmployee.Password = AND pEmployee.Emp_Type = 'Employee' AND pEmployee.Status = 0 AND pEmployee.Loc_ID = SELECT SCHEMA_NAME FROM information_schema.schemata WHERE SCHEMA_NAME = INSERT INTO #agency_db#.ptmeds_ai ( Patient_ID, Drug_ID, Status, DateOrdered, DateDCed, Drug_Name, Dose, Dose_Units, Route, Freq, Notes, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , , , ) SELECT * FROM #agency_db#.ptmeds_ai WHERE PtMeds_ID = INSERT INTO #agency_db#.ptmeds_ai ( Patient_ID, Drug_ID, Status, DateOrdered, DateDCed, Drug_Name, Dose, Dose_Units, Route, Freq, Notes, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , , , ) SELECT * FROM #agency_db#.ptmeds_ai WHERE Patient_ID = ORDER BY Date_Create DESC