09:32:36 - IsConnectionValid True 09:32:37 - IsConnectionValid True 09:32:42 - IsConnectionValid True 09:32:42 - IsConnectionValid True 09:32:46 - IsConnectionValid True 09:32:48 - IsConnectionValid True 09:32:48 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 09:40:20 - IsConnectionValid True 09:40:21 - IsConnectionValid True 09:40:21 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 09:41:01 - IsConnectionValid True 09:41:02 - IsConnectionValid True 09:41:02 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 09:44:24 - IsConnectionValid True 14:00:20 - IsConnectionValid True 14:00:21 - IsConnectionValid True 14:00:28 - IsConnectionValid True 14:00:28 - IsConnectionValid True 14:02:10 - IsConnectionValid True 14:02:11 - IsConnectionValid True 14:02:47 - IsConnectionValid True 14:02:47 - IsConnectionValid True 14:05:27 - IsConnectionValid True 14:05:27 - IsConnectionValid True 14:06:46 - IsConnectionValid True 14:06:47 - IsConnectionValid True 14:07:41 - IsConnectionValid True 14:07:41 - IsConnectionValid True 14:07:46 - IsConnectionValid True 14:07:46 - IsConnectionValid True 14:43:16 - IsConnectionValid True 14:43:30 - IsConnectionValid True 14:43:34 - IsConnectionValid True 14:44:11 - IsConnectionValid True 14:44:18 - IsConnectionValid True 14:44:18 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:18 - IsConnectionValid True 14:44:18 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:20 - IsConnectionValid True 14:44:20 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:20 - IsConnectionValid True 14:44:20 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:22 - IsConnectionValid True 14:44:41 - IsConnectionValid True 14:44:41 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:41 - IsConnectionValid True 14:44:41 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:44:47 - IsConnectionValid True 14:44:48 - IsConnectionValid True 14:44:50 - IsConnectionValid True 14:46:08 - IsConnectionValid True 14:46:10 - IsConnectionValid True 14:46:16 - IsConnectionValid True 14:46:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:46:16 - IsConnectionValid True 14:46:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:46:20 - IsConnectionValid True 14:46:20 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:46:20 - IsConnectionValid True 14:46:20 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:46:26 - IsConnectionValid True 14:47:13 - IsConnectionValid True 14:47:17 - IsConnectionValid True 14:47:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:47:17 - IsConnectionValid True 14:47:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:47:20 - IsConnectionValid True 14:50:28 - IsConnectionValid True 14:50:36 - IsConnectionValid True 14:50:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:50:36 - IsConnectionValid True 14:50:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:50:39 - IsConnectionValid True 14:53:36 - IsConnectionValid True 14:53:39 - IsConnectionValid True 14:53:40 - IsConnectionValid True 14:53:40 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:53:40 - IsConnectionValid True 14:53:40 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:53:43 - IsConnectionValid True 14:54:22 - IsConnectionValid True 14:54:25 - IsConnectionValid True 14:54:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:54:25 - IsConnectionValid True 14:54:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:54:30 - IsConnectionValid True 14:56:16 - IsConnectionValid True 14:56:19 - IsConnectionValid True 14:56:19 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:56:20 - IsConnectionValid True 14:56:20 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:56:24 - IsConnectionValid True 14:56:59 - IsConnectionValid True 14:57:03 - IsConnectionValid True 14:57:03 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:57:03 - IsConnectionValid True 14:57:03 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 14:57:13 - IsConnectionValid True 15:03:22 - IsConnectionValid True 15:03:25 - IsConnectionValid True 15:03:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:03:25 - IsConnectionValid True 15:03:25 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:03:30 - IsConnectionValid True 15:06:09 - IsConnectionValid True 15:06:12 - IsConnectionValid True 15:06:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:06:12 - IsConnectionValid True 15:06:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:06:16 - IsConnectionValid True 15:09:22 - IsConnectionValid True 15:09:26 - IsConnectionValid True 15:09:26 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:09:26 - IsConnectionValid True 15:09:26 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:09:31 - IsConnectionValid True 15:10:04 - IsConnectionValid True 15:10:08 - IsConnectionValid True 15:10:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:10:08 - IsConnectionValid True 15:10:08 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:10:12 - IsConnectionValid True 15:11:04 - IsConnectionValid True 15:11:04 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:11:04 - IsConnectionValid True 15:11:04 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:11:09 - IsConnectionValid True 15:11:12 - IsConnectionValid True 15:11:16 - IsConnectionValid True 15:11:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:11:17 - IsConnectionValid True 15:11:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:11:20 - IsConnectionValid True 15:11:57 - IsConnectionValid True 15:12:03 - IsConnectionValid True 15:12:03 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:12:03 - IsConnectionValid True 15:12:03 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:12:09 - IsConnectionValid True 15:13:53 - IsConnectionValid True 15:13:57 - IsConnectionValid True 15:13:57 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:13:57 - IsConnectionValid True 15:13:57 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:14:02 - IsConnectionValid True 15:14:46 - IsConnectionValid True 15:14:50 - IsConnectionValid True 15:14:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:14:50 - IsConnectionValid True 15:14:50 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:14:54 - IsConnectionValid True 15:16:23 - IsConnectionValid True 15:16:27 - IsConnectionValid True 15:16:27 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:16:27 - IsConnectionValid True 15:16:27 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:16:31 - IsConnectionValid True 15:18:04 - IsConnectionValid True 15:18:04 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:18:04 - IsConnectionValid True 15:18:04 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:18:09 - IsConnectionValid True 15:18:11 - IsConnectionValid True 15:20:26 - IsConnectionValid True 15:20:29 - IsConnectionValid True 15:20:29 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:20:29 - IsConnectionValid True 15:20:29 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:20:34 - IsConnectionValid True 15:20:51 - IsConnectionValid True 15:20:54 - IsConnectionValid True 15:20:54 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:20:54 - IsConnectionValid True 15:20:54 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:20:57 - IsConnectionValid True 15:33:08 - IsConnectionValid True 15:33:11 - IsConnectionValid True 15:33:11 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:11 - IsConnectionValid True 15:33:11 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:17 - IsConnectionValid True 15:33:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:33:17 - IsConnectionValid True 15:33:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:33:26 - IsConnectionValid True 15:33:26 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:26 - IsConnectionValid True 15:33:26 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:28 - IsConnectionValid True 15:33:39 - IsConnectionValid True 15:33:39 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:39 - IsConnectionValid True 15:33:39 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:33:45 - IsConnectionValid True 15:34:19 - IsConnectionValid True 15:34:22 - IsConnectionValid True 15:34:22 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:34:22 - IsConnectionValid True 15:34:22 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:34:26 - IsConnectionValid True 15:34:26 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:34:26 - IsConnectionValid True 15:34:26 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:34:30 - IsConnectionValid True 15:34:33 - IsConnectionValid True 15:34:33 - IsConnectionValid True 15:36:27 - IsConnectionValid True 15:36:30 - IsConnectionValid True 15:36:30 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:36:31 - IsConnectionValid True 15:36:31 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:36:36 - IsConnectionValid True 15:36:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:36:36 - IsConnectionValid True 15:36:36 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:36:43 - IsConnectionValid True 15:37:03 - IsConnectionValid True 15:37:03 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:03 - IsConnectionValid True 15:37:03 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:09 - IsConnectionValid True 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:12 - IsConnectionValid True 15:37:12 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:15 - IsConnectionValid True 15:37:17 - IsConnectionValid True 15:37:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:37:18 - IsConnectionValid True 15:37:18 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:37:22 - IsConnectionValid True 15:37:25 - IsConnectionValid True 15:37:25 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:25 - IsConnectionValid True 15:37:25 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:37:28 - IsConnectionValid True 15:38:31 - IsConnectionValid True 15:38:54 - IsConnectionValid True 15:39:28 - IsConnectionValid True 15:39:28 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:39:28 - IsConnectionValid True 15:39:28 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:39:33 - IsConnectionValid True 15:40:17 - IsConnectionValid True 15:40:18 - IsConnectionValid True 15:40:18 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 15:40:18 - (1-gen-1002) : Invalid object name 'Schools'. 15:41:16 - IsConnectionValid True 15:41:17 - IsConnectionValid True 15:41:17 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 15:41:17 - (1-gen-1002) : Invalid object name 'Schools'. 15:41:18 - IsConnectionValid True 15:41:19 - IsConnectionValid True 15:41:26 - IsConnectionValid True 15:42:49 - IsConnectionValid True 15:42:53 - IsConnectionValid True 15:43:27 - IsConnectionValid True 15:43:34 - IsConnectionValid True 15:43:34 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:43:34 - IsConnectionValid True 15:43:34 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:43:39 - IsConnectionValid True 15:44:32 - IsConnectionValid True 15:44:41 - IsConnectionValid True 15:44:41 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:44:41 - IsConnectionValid True 15:44:41 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:44:46 - IsConnectionValid True 15:47:15 - IsConnectionValid True 15:47:17 - IsConnectionValid True 15:47:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:47:17 - IsConnectionValid True 15:47:17 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:47:22 - IsConnectionValid True 15:48:12 - IsConnectionValid True 15:48:16 - IsConnectionValid True 15:48:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:48:16 - IsConnectionValid True 15:48:16 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:48:21 - IsConnectionValid True 15:48:29 - IsConnectionValid True 15:48:29 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM vwDepartments WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) ORDER BY Code ASC Query 15:48:29 - IsConnectionValid True 15:48:29 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM vwDepartments WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) ORDER BY Code ASC Query 15:48:48 - IsConnectionValid True 15:48:52 - IsConnectionValid True 15:48:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:48:52 - IsConnectionValid True 15:48:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 15:48:56 - IsConnectionValid True 15:49:41 - IsConnectionValid True 15:49:41 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:49:41 - IsConnectionValid True 15:49:41 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:49:45 - IsConnectionValid True 15:49:56 - IsConnectionValid True 15:49:56 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:49:56 - IsConnectionValid True 15:49:56 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY Code ASC Query 15:50:01 - IsConnectionValid True 15:52:56 - IsConnectionValid True 15:53:01 - IsConnectionValid True 15:53:01 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 15:53:01 - (1-gen-1002) : Invalid object name 'Schools'. 15:53:07 - IsConnectionValid True 15:53:07 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 15:53:07 - IsConnectionValid True 15:53:07 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 15:53:12 - IsConnectionValid True 15:53:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 15:53:12 - IsConnectionValid True 15:53:12 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and ((0=0 and DateLeft='01/01/1900') or (0=1 and DateLeft<>'01/01/1900' ) or 0=2 ) ORDER BY Code ASC Query 15:53:21 - IsConnectionValid True 15:53:47 - IsConnectionValid True 15:53:56 - IsConnectionValid True 15:53:58 - IsConnectionValid True 15:54:03 - IsConnectionValid True 15:54:10 - IsConnectionValid True 15:54:12 - IsConnectionValid True 15:54:12 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 15:54:12 - (1-gen-1002) : Invalid object name 'Schools'. 15:54:14 - IsConnectionValid True 16:06:25 - IsConnectionValid True 16:06:25 - IsConnectionValid True 16:06:36 - IsConnectionValid True 16:06:47 - IsConnectionValid True 16:06:47 - IsConnectionValid True 16:06:51 - IsConnectionValid True 16:16:52 - IsConnectionValid True 16:16:54 - IsConnectionValid True 16:16:54 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:16:56 - IsConnectionValid True 16:16:56 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >08/14/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:16:58 - IsConnectionValid True 16:16:58 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:17:07 - IsConnectionValid True 16:17:10 - IsConnectionValid True 16:17:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:17:11 - IsConnectionValid True 16:17:11 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 16:17:12 - IsConnectionValid True 16:17:12 - IsConnectionValid True 16:17:12 - IsConnectionValid True 16:17:12 - IsConnectionValid True 16:17:12 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query