15:30:02 - IsConnectionValid True 15:30:55 - IsConnectionValid True 15:30:56 - IsConnectionValid True 15:30:56 - IsConnectionValid True 15:31:02 - IsConnectionValid True 15:31:02 - IsConnectionValid True 15:31:07 - IsConnectionValid True 15:31:10 - IsConnectionValid True 15:31:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:31:15 - IsConnectionValid True 15:31:19 - IsConnectionValid True 15:31:19 - 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, TotalSal AS BasicSalary 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 15:31:19 - IsConnectionValid True 15:31:19 - 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, TotalSal AS BasicSalary 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 15:31:28 - IsConnectionValid True 15:31:28 - 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, TotalSal AS BasicSalary 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 15:31:28 - IsConnectionValid True 15:31:28 - 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, TotalSal AS BasicSalary 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 15:31:42 - IsConnectionValid True 15:31: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, 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, TotalSal AS BasicSalary 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 15:31:42 - IsConnectionValid True 15:31:42 - 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, TotalSal AS BasicSalary 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 15:31:52 - IsConnectionValid True 15:31:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) AND Sign = @val7 AND IsReturnEffect = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:31:57 - IsConnectionValid True 15:32:00 - IsConnectionValid True 15:32:01 - IsConnectionValid True 15:32:01 - SELECT Name_E AS Name_E, LAST_NO AS LAST_NO FROM VOU001 WHERE vTypeAlias = @val0 ORDER BY ID Query 15:32:01 - IsConnectionValid True 15:32:04 - IsConnectionValid True 15:32:05 - IsConnectionValid True 15:32:13 - IsConnectionValid True 15:32:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:32:15 - IsConnectionValid True 15:32:15 - SELECT DISTINCT * FROM VwJobs_Details WHERE TenantID = 1 AND TenantID = @val0 AND MasterID = @val1 Query 15:32:18 - IsConnectionValid True 15:32:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Classification WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:36:14 - IsConnectionValid True 15:36:16 - IsConnectionValid True 15:36:16 - SELECT DISTINCT * FROM VwJobs_Details WHERE TenantID = 1 AND TenantID = @val0 AND MasterID = @val1 Query 15:36:18 - IsConnectionValid True 15:36:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:21 - IsConnectionValid True 15:37:22 - IsConnectionValid True 15:37:22 - SELECT DISTINCT * FROM VwJobs_Details WHERE TenantID = 1 AND TenantID = @val0 AND MasterID = @val1 Query 15:37:24 - IsConnectionValid True 15:37:24 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:26 - IsConnectionValid True 15:37:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:29 - IsConnectionValid True 15:37:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:33 - IsConnectionValid True 15:37:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:36 - IsConnectionValid True 15:37:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:38 - IsConnectionValid True 15:37:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:39 - IsConnectionValid True 15:37:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:41 - IsConnectionValid True 15:37:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:42 - IsConnectionValid True 15:37:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:44 - IsConnectionValid True 15:37:44 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:45 - IsConnectionValid True 15:37:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:37:47 - IsConnectionValid True 15:37:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:13 - IsConnectionValid True 15:41:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:16 - IsConnectionValid True 15:41:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:41:18 - IsConnectionValid True 15:41:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM Departments WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:54:24 - IsConnectionValid True 15:54:27 - IsConnectionValid True 15:54:27 - SELECT DISTINCT * FROM VwJobs_Details WHERE TenantID = 1 AND TenantID = @val0 AND MasterID = @val1 Query 15:54:47 - IsConnectionValid True 15:54:54 - IsConnectionValid True 15:54:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:00 - IsConnectionValid True 15:55:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:00 - IsConnectionValid True 15:55:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:01 - IsConnectionValid True 15:55:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:01 - IsConnectionValid True 15:55:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:03 - IsConnectionValid True 15:55:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:03 - IsConnectionValid True 15:55:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:03 - IsConnectionValid True 15:55:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:03 - IsConnectionValid True 15:55:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:05 - IsConnectionValid True 15:55:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:05 - IsConnectionValid True 15:55:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:06 - IsConnectionValid True 15:55:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:06 - IsConnectionValid True 15:55:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:17 - IsConnectionValid True 15:55:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 AND EName LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:18 - IsConnectionValid True 15:55:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 AND EName LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:18 - IsConnectionValid True 15:55:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 AND EName LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:18 - IsConnectionValid True 15:55:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwJobs WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 AND EName LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:26 - IsConnectionValid True 15:55:35 - IsConnectionValid True 15:55:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:16 - IsConnectionValid True 15:58:22 - IsConnectionValid True 15:58:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:29 - IsConnectionValid True 15:58:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =22 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:33 - IsConnectionValid True 15:58:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =92 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:35 - IsConnectionValid True 15:58:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:40 - IsConnectionValid True 15:58:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =92 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:48 - IsConnectionValid True 15:58:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =92 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:48 - IsConnectionValid True 15:58:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =92 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:49 - IsConnectionValid True 15:58:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =92 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:58:53 - IsConnectionValid True 15:58:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1026 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:59:11 - IsConnectionValid True 15:59:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1026 and DateLeft = '1900-01-01' and EnglishName LIKE '%m%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:59:20 - IsConnectionValid True 15:59:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1026 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:59:23 - IsConnectionValid True 15:59:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1026 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:59:28 - IsConnectionValid True 15:59:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1026 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow