00:30:29 - IsConnectionValid True 00:30:31 - IsConnectionValid True 00:30:51 - IsConnectionValid True 00:30:52 - IsConnectionValid True 00:31:08 - IsConnectionValid True 00:31:17 - IsConnectionValid True 00:31:36 - IsConnectionValid True 00:31: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:31:43 - IsConnectionValid True 00:31:43 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:31:46 - IsConnectionValid True 00:31:46 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:35:21 - IsConnectionValid True 00:35: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:35:24 - IsConnectionValid True 00:35:24 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:35:32 - IsConnectionValid True 00:35: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:35:36 - IsConnectionValid True 00:35:37 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:35:38 - IsConnectionValid True 00:35:38 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:35:54 - IsConnectionValid True 00:36:44 - IsConnectionValid True 00:37:28 - IsConnectionValid True 00:37: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:37:37 - IsConnectionValid True 00:37:37 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:37:41 - IsConnectionValid True 00:37:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:55:06 - IsConnectionValid True 00:55:24 - IsConnectionValid True 00:55: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:55:29 - IsConnectionValid True 00:55:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:55:32 - IsConnectionValid True 00:55:32 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:55:57 - IsConnectionValid True 00:56:16 - IsConnectionValid True 00:56:16 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:56:21 - IsConnectionValid True 00:56:21 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 00:56:23 - IsConnectionValid True 00:56:23 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:01:30 - IsConnectionValid True 01:01:30 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:02:42 - IsConnectionValid True 01:02:44 - IsConnectionValid True 01:02:44 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:02:56 - IsConnectionValid True 01:08:09 - IsConnectionValid True 01:08:38 - IsConnectionValid True 01:08:38 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:08:43 - IsConnectionValid True 01:08:44 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:08:46 - IsConnectionValid True 01:08:46 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:09:00 - IsConnectionValid True 01:09: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, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:09:11 - IsConnectionValid True 01:09:12 - IsConnectionValid True 01:09:12 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:09:27 - IsConnectionValid True 01:09: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:09:32 - IsConnectionValid True 01:09:32 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 01:09:34 - IsConnectionValid True 01:09:34 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:20:53 - IsConnectionValid True 11:20:54 - IsConnectionValid True 11:20:55 - IsConnectionValid True 11:21:02 - IsConnectionValid True 11:21:03 - IsConnectionValid True 11:24:58 - IsConnectionValid True 11:35:56 - IsConnectionValid True 11:36:35 - IsConnectionValid True 11:37:56 - IsConnectionValid True 11:39:16 - IsConnectionValid True 11:40:19 - IsConnectionValid True 11:44:21 - IsConnectionValid True 11:48:40 - IsConnectionValid True 11:49:41 - IsConnectionValid True 11:49:42 - IsConnectionValid True 11:49:49 - IsConnectionValid True 11:49:54 - IsConnectionValid True 11:49: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:49:56 - IsConnectionValid True 11:49:56 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:49:57 - IsConnectionValid True 11:49:57 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:50:47 - IsConnectionValid True 11:50:47 - IsConnectionValid True 11:50:47 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:50:49 - IsConnectionValid True 11:50:49 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:50:50 - IsConnectionValid True 11:50:50 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:50:51 - IsConnectionValid True 11:50:51 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:51:43 - IsConnectionValid True 11:51:43 - IsConnectionValid True 11:51:43 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:51:46 - IsConnectionValid True 11:51:46 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:10 - IsConnectionValid True 11:53:10 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:10 - IsConnectionValid True 11:53:10 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:18 - IsConnectionValid True 11:53:18 - IsConnectionValid True 11:53:18 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:34 - IsConnectionValid True 11:53: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:35 - IsConnectionValid True 11:53:35 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:35 - IsConnectionValid True 11:53:35 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:40 - IsConnectionValid True 11:53:40 - IsConnectionValid True 11:53:40 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:41 - IsConnectionValid True 11:53: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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:55 - IsConnectionValid True 11:53:55 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:58 - IsConnectionValid True 11:53: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:59 - IsConnectionValid True 11:53:59 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:53:59 - IsConnectionValid True 11:53:59 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:54:21 - IsConnectionValid True 11:54:21 - IsConnectionValid True 11:54:21 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:54:23 - IsConnectionValid True 11:54: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:54:24 - IsConnectionValid True 11:54:24 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:54:24 - IsConnectionValid True 11:54:24 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:55:29 - IsConnectionValid True 11:55:29 - IsConnectionValid True 11:55:29 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:55:48 - IsConnectionValid True 11:55:48 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:55:48 - IsConnectionValid True 11:55:48 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:55:48 - IsConnectionValid True 11:55:48 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:55:51 - IsConnectionValid True 11:55:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:55:58 - IsConnectionValid True 11:55:58 - IsConnectionValid True 11:55:58 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:56:00 - IsConnectionValid True 11:56: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:56:02 - IsConnectionValid True 11:56:02 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:56:02 - IsConnectionValid True 11:56:02 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:59:18 - IsConnectionValid True 11:59:29 - IsConnectionValid True 11:59:29 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:59:30 - IsConnectionValid True 11:59:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:59:30 - IsConnectionValid True 11:59:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 11:59:34 - IsConnectionValid True 11:59: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, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:59:38 - IsConnectionValid True 11:59:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:01:10 - IsConnectionValid True 12:01:16 - IsConnectionValid True 12:01:16 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:01:17 - IsConnectionValid True 12:01:17 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:01:17 - IsConnectionValid True 12:01:17 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:01:19 - IsConnectionValid True 12:01: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, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:02:04 - IsConnectionValid True 12:06:51 - IsConnectionValid True 12:07:45 - IsConnectionValid True 12:07:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:07:48 - IsConnectionValid True 12:07:48 - IsConnectionValid True 12:07:48 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:07:51 - IsConnectionValid True 12:07:51 - 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, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:07:52 - IsConnectionValid True 12:07:52 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:07:52 - IsConnectionValid True 12:07:52 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:09:02 - IsConnectionValid True 12:10:21 - IsConnectionValid True 12:10:32 - IsConnectionValid True 12:10: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >03/06/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:10:33 - IsConnectionValid True 12:10:33 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:10:33 - IsConnectionValid True 12:10:33 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 12:10:36 - IsConnectionValid True 12:11:33 - IsConnectionValid True 14:41:15 - IsConnectionValid True