MyHomeCareBiz

SELECT Employee.Employee_ID, Employee.Authority_Level, CONCAT(Employee.First_Name, " ", Employee.Last_Name) AS Full_Name, Employee.Username, Employee.Password, Agency.Agency_Name, Agency.Agency_Login, Agency.Agency_ID FROM #Request.prefix_db_lookup#.Employee LEFT JOIN #Request.prefix_db_lookup#.Agency ON Employee.Agency_ID = Agency.Agency_ID WHERE Username = AND Password = AND Agency.Status = AND Employee.Status = AND Employee.EmployeeType != 'Physician' INSERT INTO #Request.prefix_db_lookup#.Logon (Agency_ID, Employee_ID, Logon_Date, User_IP) VALUES (#Login.Agency_ID#, #Login.Employee_ID#, #CreateODBCDateTime(Now())#, '#REMOTE_ADDR#' ) MyHomeCareBiz

Sign In