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#.problems_ai ( Patient_AI_ID, Assmt_ID, Status, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , ) SELECT * FROM #agency_db#.problems_ai WHERE Problem_ID = INSERT INTO #agency_db#.problems_ai ( Patient_AI_ID, Assmt_ID, Status, M0_No, Description, Answer, Severity, dx_order, Oasis_Deficits, Date_Create, Created_by, Date_Change, Change_by, record_timestamp ) VALUES ( , , , , , , , , , , , , , ) SELECT * FROM #agency_db#.problems_ai WHERE Patient_AI_ID = ORDER BY Date_Create DESC