10:27:16 - IsConnectionValid True 10:27:17 - IsConnectionValid True 10:27:17 - IsConnectionValid True 10:27:24 - IsConnectionValid True 10:27:24 - IsConnectionValid True 10:27:28 - IsConnectionValid True 10:27:46 - IsConnectionValid True 10:27:46 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:27:59 - IsConnectionValid True 10:27:59 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 Query 10:27:59 - IsConnectionValid True 10:27:59 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 Query 10:28:08 - IsConnectionValid True 10:28:54 - IsConnectionValid True 10:28:55 - IsConnectionValid True 10:29:39 - IsConnectionValid True 10:29:39 - IsConnectionValid True 10:29:43 - IsConnectionValid True 10:29:43 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:31:11 - IsConnectionValid True 10:31:13 - IsConnectionValid True 10:31:13 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:31:16 - IsConnectionValid True 10:31:49 - IsConnectionValid True 10:31:49 - IsConnectionValid True 10:31:58 - IsConnectionValid True 10:31:59 - IsConnectionValid True 10:32:01 - IsConnectionValid True 10:32:01 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:32:29 - IsConnectionValid True 10:32:37 - IsConnectionValid True 10:32:57 - IsConnectionValid True 10:32:57 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:33:21 - IsConnectionValid True 10:33:24 - IsConnectionValid True 10:33:33 - IsConnectionValid True 10:33:33 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 10:33:33 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0) COUNT Query 7 10:33:35 - IsConnectionValid True 10:33:41 - IsConnectionValid True 10:33:41 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:33:41 - IsConnectionValid True 10:33:41 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:35:12 - IsConnectionValid True 10:35:15 - IsConnectionValid True 10:35:15 - SELECT ID AS ID, Code AS Code, Name AS Name, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:35:15 - IsConnectionValid True 10:35:15 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:38:55 - IsConnectionValid True 10:38:58 - IsConnectionValid True 10:38:58 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:38:59 - IsConnectionValid True 10:38:59 - 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, EName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:39:04 - IsConnectionValid True 10:39:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:39:04 - IsConnectionValid True 10:39:04 - 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, EName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:39:57 - IsConnectionValid True 10:40:00 - IsConnectionValid True 10:40:00 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:40:00 - IsConnectionValid True 10:40:00 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:40:08 - IsConnectionValid True 10:40:08 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:40:11 - IsConnectionValid True 10:40:11 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:40:25 - IsConnectionValid True 10:40:25 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:40:32 - IsConnectionValid True 10:40:32 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:40:37 - IsConnectionValid True 10:40:37 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:41:22 - IsConnectionValid True 10:41:24 - IsConnectionValid True 10:41:24 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:41:24 - IsConnectionValid True 10:41:24 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:41:33 - IsConnectionValid True 10:41:33 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:41:37 - IsConnectionValid True 10:41:37 - 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, EnglishName AS EName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:15 - IsConnectionValid True 10:42:17 - IsConnectionValid True 10:42:17 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:42:17 - IsConnectionValid True 10:42:17 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:23 - IsConnectionValid True 10:42:23 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EnglishName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:27 - IsConnectionValid True 10:42:27 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EnglishName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:31 - IsConnectionValid True 10:42:31 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EnglishName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:42:36 - IsConnectionValid True 10:42:36 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND EnglishName LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:43:57 - IsConnectionValid True 10:44:00 - IsConnectionValid True 10:44:00 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 10:44:00 - IsConnectionValid True 10:44:00 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:45:16 - IsConnectionValid True 10:45:27 - IsConnectionValid True 10:45:29 - IsConnectionValid True 10:45:29 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 10:45:29 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0) COUNT Query 7 10:45:31 - IsConnectionValid True 10:45:33 - IsConnectionValid True 10:45:35 - IsConnectionValid True 10:45:35 - IsConnectionValid True 10:45:39 - IsConnectionValid True 10:45:39 - 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 10:45:39 - IsConnectionValid True 10:45:39 - 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 10:45:41 - IsConnectionValid True 10:46:40 - IsConnectionValid True 10:46:43 - IsConnectionValid True 10:46:43 - 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 10:46:43 - IsConnectionValid True 10:46:43 - 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 10:46:46 - IsConnectionValid True 11:35:23 - IsConnectionValid True 11:35:31 - IsConnectionValid True 11:35:32 - IsConnectionValid True 11:35:32 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:36:15 - IsConnectionValid True 11:36:17 - IsConnectionValid True 11:36:17 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:37:06 - IsConnectionValid True 11:37:08 - IsConnectionValid True 11:37:08 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:37:37 - IsConnectionValid True 11:37:39 - IsConnectionValid True 11:37:39 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:37:42 - IsConnectionValid True 11:37:42 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:37:43 - IsConnectionValid True 11:37:43 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:37:54 - IsConnectionValid True 11:37:54 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:37:54 - IsConnectionValid True 11:37:54 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:38:00 - IsConnectionValid True 11:38:00 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:38:00 - IsConnectionValid True 11:38:00 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:38:51 - IsConnectionValid True 11:38:53 - IsConnectionValid True 11:38:53 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:38:55 - IsConnectionValid True 11:38:56 - IsConnectionValid True 11:38:56 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:39:30 - IsConnectionValid True 11:39:31 - IsConnectionValid True 11:39:31 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:39:37 - IsConnectionValid True 11:39:37 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:39:37 - IsConnectionValid True 11:39:37 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:41:33 - IsConnectionValid True 11:41:35 - IsConnectionValid True 11:41:35 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:41:37 - IsConnectionValid True 11:41:37 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:41:37 - IsConnectionValid True 11:41:37 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:43:10 - IsConnectionValid True 11:43:13 - IsConnectionValid True 11:43:13 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:43:18 - IsConnectionValid True 11:43:19 - IsConnectionValid True 11:43:19 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:43:30 - IsConnectionValid True 11:43:30 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:43:31 - IsConnectionValid True 11:43:31 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:43:36 - IsConnectionValid True 11:43:36 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:43:41 - IsConnectionValid True 11:43:41 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:43:41 - IsConnectionValid True 11:43:41 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:43:53 - IsConnectionValid True 11:43:54 - IsConnectionValid True 11:43:54 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:44:26 - IsConnectionValid True 11:44:28 - IsConnectionValid True 11:44:28 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:44:48 - IsConnectionValid True 11:44:52 - IsConnectionValid True 11:44:53 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:45:14 - IsConnectionValid True 11:45:16 - IsConnectionValid True 11:45:16 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:45:19 - IsConnectionValid True 11:45:22 - IsConnectionValid True 11:45:22 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:45:31 - IsConnectionValid True 11:45:31 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:45:31 - IsConnectionValid True 11:45:31 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:45:34 - IsConnectionValid True 11:45:34 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:45:34 - IsConnectionValid True 11:45:34 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:09 - IsConnectionValid True 11:47:11 - IsConnectionValid True 11:47:11 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:14 - IsConnectionValid True 11:47:14 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:47:15 - IsConnectionValid True 11:47:15 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:27 - IsConnectionValid True 11:47:29 - IsConnectionValid True 11:47:29 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:31 - IsConnectionValid True 11:47:31 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:47:31 - IsConnectionValid True 11:47:31 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:35 - IsConnectionValid True 11:47:35 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:47:36 - IsConnectionValid True 11:47:36 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:54 - IsConnectionValid True 11:47:56 - IsConnectionValid True 11:47:56 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:47:59 - IsConnectionValid True 11:48:01 - IsConnectionValid True 11:48:01 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:48:02 - IsConnectionValid True 11:48:02 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:48:02 - IsConnectionValid True 11:48:02 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:48:35 - IsConnectionValid True 11:48:37 - IsConnectionValid True 11:48:37 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:48:39 - IsConnectionValid True 11:48:39 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:48:40 - IsConnectionValid True 11:48:40 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:49:11 - IsConnectionValid True 11:49:13 - IsConnectionValid True 11:49:13 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:49:16 - IsConnectionValid True 11:49:17 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:49:17 - IsConnectionValid True 11:49:17 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:49:49 - IsConnectionValid True 11:49:49 - IsConnectionValid True 11:49:51 - IsConnectionValid True 11:49:53 - IsConnectionValid True 11:49:53 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:49:55 - IsConnectionValid True 11:49:56 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:49:56 - IsConnectionValid True 11:49:56 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:49:58 - IsConnectionValid True 11:49:58 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:49:58 - IsConnectionValid True 11:49:58 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:50:02 - IsConnectionValid True 11:50:02 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:50:03 - IsConnectionValid True 11:50:03 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:09 - IsConnectionValid True 11:51:10 - IsConnectionValid True 11:51:10 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:51:12 - IsConnectionValid True 11:51:12 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:51:12 - IsConnectionValid True 11:51:12 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:15 - IsConnectionValid True 11:51:15 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:51:15 - IsConnectionValid True 11:51:15 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:18 - IsConnectionValid True 11:51:18 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:51:18 - IsConnectionValid True 11:51:18 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:59 - IsConnectionValid True 11:52:02 - IsConnectionValid True 11:52:02 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:52:03 - IsConnectionValid True 11:52:03 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:52:04 - IsConnectionValid True 11:52:04 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:52:15 - IsConnectionValid True 11:52:16 - IsConnectionValid True 11:52:16 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:52:18 - IsConnectionValid True 11:52:18 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:52:18 - IsConnectionValid True 11:52:18 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:52:21 - IsConnectionValid True 11:52:21 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:52:21 - IsConnectionValid True 11:52:21 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:52:39 - IsConnectionValid True 11:52:40 - IsConnectionValid True 11:52:40 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:53:10 - IsConnectionValid True 11:53:11 - IsConnectionValid True 11:53:11 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:53:13 - IsConnectionValid True 11:53:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:53:14 - IsConnectionValid True 11:53:14 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:15 - IsConnectionValid True 11:53:15 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:53:15 - IsConnectionValid True 11:53:15 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:54:22 - IsConnectionValid True 11:54:22 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:54:22 - IsConnectionValid True 11:54:22 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:55:55 - IsConnectionValid True 11:55:55 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:55:55 - IsConnectionValid True 11:55:55 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:55:57 - IsConnectionValid True 11:55:57 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (Code LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY ID ASC Query 11:55:57 - IsConnectionValid True 11:55:57 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:52:20 - IsConnectionValid True 13:03:33 - IsConnectionValid True 13:04:24 - IsConnectionValid True 13:05:25 - IsConnectionValid True 13:05:36 - IsConnectionValid True 13:05:51 - IsConnectionValid True 13:06:35 - IsConnectionValid True 13:07:35 - IsConnectionValid True 13:08:16 - IsConnectionValid True 13:08:54 - IsConnectionValid True 13:09:40 - IsConnectionValid True 13:10:50 - IsConnectionValid True 13:10:54 - IsConnectionValid True 13:10:55 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 13:11:33 - IsConnectionValid True 13:11:35 - IsConnectionValid True 13:11:35 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 13:11:39 - IsConnectionValid True 13:11:41 - IsConnectionValid True 13:11:41 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 13:13:02 - IsConnectionValid True 13:13:03 - IsConnectionValid True 13:13:03 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 13:13:53 - IsConnectionValid True 13:13:54 - IsConnectionValid True 13:14:10 - IsConnectionValid True 13:14:10 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:14:26 - IsConnectionValid True 13:15:49 - IsConnectionValid True 13:15:50 - IsConnectionValid True 13:15:56 - IsConnectionValid True 13:15:56 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:17:00 - IsConnectionValid True 13:17:03 - IsConnectionValid True 13:17:03 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:28:48 - IsConnectionValid True 13:28:51 - IsConnectionValid True 13:28:51 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:28:54 - IsConnectionValid True 13:29:06 - IsConnectionValid True 13:29:07 - IsConnectionValid True 13:29:20 - IsConnectionValid True 13:40:28 - IsConnectionValid True 13:40:31 - IsConnectionValid True 13:40:31 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:41:47 - IsConnectionValid True 13:41:49 - IsConnectionValid True 13:41:49 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:41:52 - IsConnectionValid True 13:41:52 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE TenantID = 1 AND TenantID = @val0 AND E.UserID = @val1 GROUP BY J.Name ORDER BY OrderNo Query 13:41:52 - (1-gen-1002) : Ambiguous column name 'TenantID'. Ambiguous column name 'TenantID'. Invalid column name 'OrderNo'. 13:42:10 - IsConnectionValid True 13:42:13 - IsConnectionValid True 13:42:13 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:42:15 - IsConnectionValid True 13:42:15 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE TenantID = 1 AND E.TenantID = @val0 AND E.UserID = @val1 GROUP BY J.Name ORDER BY OrderNo Query 13:42:15 - (1-gen-1002) : Ambiguous column name 'TenantID'. Invalid column name 'OrderNo'. 13:42:47 - IsConnectionValid True 13:42:50 - IsConnectionValid True 13:42:50 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:42:53 - IsConnectionValid True 13:42:53 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE TenantID = 1 AND E.TenantID = @val0 AND E.UserID = @val1 GROUP BY J.Name Query 13:42:53 - (1-gen-1002) : Ambiguous column name 'TenantID'. 13:43:09 - IsConnectionValid True 13:43:15 - IsConnectionValid True 13:43:15 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:43:16 - IsConnectionValid True 13:43:16 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 GROUP BY J.Name Query 13:46:08 - IsConnectionValid True 13:46:10 - IsConnectionValid True 13:46:10 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:46:15 - IsConnectionValid True 13:46:15 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:46:15 - IsConnectionValid True 13:46:15 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:46:32 - IsConnectionValid True 13:46:32 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:46:32 - IsConnectionValid True 13:46:32 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:47:05 - IsConnectionValid True 13:47:08 - IsConnectionValid True 13:47:08 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 13:47:11 - IsConnectionValid True 13:47:11 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:47:11 - IsConnectionValid True 13:47:11 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:47:13 - IsConnectionValid True 13:47:13 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.JobID = @val2 GROUP BY J.Name Query 14:12:47 - IsConnectionValid True 14:12:50 - IsConnectionValid True 14:12:50 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:12:58 - IsConnectionValid True 14:12:58 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 14:12:58 - IsConnectionValid True 14:12:58 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 14:13:01 - IsConnectionValid True 14:13:01 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND E.dateleft = @val5 GROUP BY J.Name Query 14:13:01 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 14:13:03 - IsConnectionValid True 14:13:03 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND E.dateleft = @val5 GROUP BY J.Name Query 14:13:03 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 14:14:12 - IsConnectionValid True 14:14:14 - IsConnectionValid True 14:14:14 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:14:15 - IsConnectionValid True 14:14:15 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.dateleft = @val2 GROUP BY J.Name Query 14:14:15 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 14:14:43 - IsConnectionValid True 14:14:46 - IsConnectionValid True 14:14:46 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:14:46 - IsConnectionValid True 14:14:46 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND CAST(E.dateleft AS Date) = @val2 GROUP BY J.Name Query 14:14:50 - IsConnectionValid True 14:14:50 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 14:14:50 - IsConnectionValid True 14:14:50 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 14:14:52 - IsConnectionValid True 14:14:52 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND CAST(E.dateleft AS Date) = @val5 GROUP BY J.Name Query 14:14:54 - IsConnectionValid True 14:14:54 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =1 or 1 =0) and (DepartmentID =5 or 5 =0) ORDER BY Code ASC Query 14:14:55 - IsConnectionValid True 14:14:55 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =1 or 1 =0) and (DepartmentID =5 or 5 =0) ORDER BY Code ASC Query 14:14:57 - IsConnectionValid True 14:14:57 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND CAST(E.dateleft AS Date) = @val5 GROUP BY J.Name Query 14:15:15 - IsConnectionValid True 14:15:15 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND CAST(E.dateleft AS Date) = @val5 GROUP BY J.Name Query 14:15:23 - IsConnectionValid True 14:15:23 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND CAST(E.dateleft AS Date) = @val5 GROUP BY J.Name Query 14:15:27 - IsConnectionValid True 14:15:27 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND E.ProjectID = @val2 AND E.DepartmentID = @val3 AND E.SectionID = @val4 AND CAST(E.datebegin AS Date) >= @val5 AND CAST(E.datebegin AS Date) <= @val6 AND CAST(E.dateleft AS Date) = @val7 GROUP BY J.Name Query 14:32:24 - IsConnectionValid True 14:32:27 - IsConnectionValid True 14:32:27 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:32:29 - IsConnectionValid True 14:34:19 - IsConnectionValid True 14:34:22 - IsConnectionValid True 14:34:22 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:34:38 - IsConnectionValid True 14:35:37 - IsConnectionValid True 14:35:37 - SELECT ISNULL(COUNT(E.ID),0) AS CountID, ISNULL(J.Name,'') AS JobName FROM HRMS_VwEmployees E INNER JOIN Jobs J ON E.JobID=J.ID WHERE E.TenantID =1 AND E.UserID = @val1 AND CAST(E.dateleft AS Date) = @val2 GROUP BY J.Name Query 14:43:33 - IsConnectionValid True 14:44:07 - IsConnectionValid True 14:44:08 - IsConnectionValid True 14:44:18 - IsConnectionValid True 14:44:18 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:44:29 - IsConnectionValid True 14:56:00 - IsConnectionValid True 14:56:01 - IsConnectionValid True 14:56:12 - IsConnectionValid True 14:56:12 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 14:56:15 - IsConnectionValid True 14:56:22 - IsConnectionValid True 14:56:22 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:47:56 - IsConnectionValid True 15:47:56 - IsConnectionValid True 15:47:58 - IsConnectionValid True 15:50:08 - IsConnectionValid True 15:50:09 - IsConnectionValid True 15:50:14 - IsConnectionValid True 15:50:15 - IsConnectionValid True 15:50:20 - IsConnectionValid True 15:50:20 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:50:23 - IsConnectionValid True 15:50:23 - SELECT sum(case when GENDER=0 AND IsJordanian=1 then 1 else 0 end) AS JordanMale, sum(case when GENDER=1 AND IsJordanian=1 then 1 else 0 end) AS JordanFemale, sum(case when GENDER=0 AND IsJordanian=0 then 1 else 0 end) AS OtherMale, sum(case when GENDER=1 AND IsJordanian=0 then 1 else 0 end) AS OtherFemale FROM vwWorkMinister WHERE TenantID =1 AND UserID = @val1 AND CAST(dateleft AS Date) = @val2 Query 15:50:23 - IsConnectionValid True 15:52:07 - IsConnectionValid True 15:52:10 - IsConnectionValid True 15:52:10 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:52:11 - IsConnectionValid True 15:52:11 - SELECT sum(case when GENDER=0 AND IsJordanian=1 then 1 else 0 end) AS JordanMale, sum(case when GENDER=1 AND IsJordanian=1 then 1 else 0 end) AS JordanFemale, sum(case when GENDER=0 AND IsJordanian=0 then 1 else 0 end) AS OtherMale, sum(case when GENDER=1 AND IsJordanian=0 then 1 else 0 end) AS OtherFemale FROM vwWorkMinister WHERE TenantID =1 AND UserID = @val1 AND CAST(dateleft AS Date) = @val2 Query 15:52:11 - IsConnectionValid True 15:53:43 - IsConnectionValid True 15:53:46 - IsConnectionValid True 15:53:46 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 15:53:52 - IsConnectionValid True 15:53:52 - SELECT sum(case when GENDER=0 AND IsJordanian=1 then 1 else 0 end) AS JordanMale, sum(case when GENDER=1 AND IsJordanian=1 then 1 else 0 end) AS JordanFemale, sum(case when GENDER=0 AND IsJordanian=0 then 1 else 0 end) AS OtherMale, sum(case when GENDER=1 AND IsJordanian=0 then 1 else 0 end) AS OtherFemale FROM vwWorkMinister WHERE TenantID =1 AND UserID = @val1 AND CAST(dateleft AS Date) = @val2 Query 15:53:52 - IsConnectionValid True 16:00:31 - IsConnectionValid True 16:00:34 - IsConnectionValid True 16:00:39 - IsConnectionValid True 16:00:39 - SELECT DISTINCT ISNULL(ShowTransactionEntryTemp,0) AS ShowTransactionEntryTemp FROM Users WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 Query 16:00:39 - IsConnectionValid True 16:00:45 - IsConnectionValid True 16:00:45 - SELECT DISTINCT ISNULL(ShowTransactionEntryTemp,0) AS ShowTransactionEntryTemp FROM Users WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 Query 16:00:45 - IsConnectionValid True 16:01:14 - IsConnectionValid True 16:01:14 - SELECT DISTINCT ISNULL(ShowTransactionEntryTemp,0) AS ShowTransactionEntryTemp FROM Users WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 Query 16:01:14 - IsConnectionValid True