10:13:50 - IsConnectionValid True 10:13:51 - IsConnectionValid True 10:13:51 - IsConnectionValid True 10:14:05 - IsConnectionValid True 10:14:05 - IsConnectionValid True 10:14:09 - IsConnectionValid True 10:14:27 - IsConnectionValid True 10:21:37 - IsConnectionValid True 10:21: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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:21:41 - IsConnectionValid True 10:21:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:21:41 - IsConnectionValid True 10:21:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:21:44 - IsConnectionValid True 10:21:44 - 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, dbo.web_get_vacationCredit(ID,175,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 and Type = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:01 - IsConnectionValid True 10:22:01 - IsConnectionValid True 10:22:01 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:03 - IsConnectionValid True 10:22: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, 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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:08 - IsConnectionValid True 10:22: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, 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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 AND Name LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:09 - IsConnectionValid True 10:22:09 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:09 - IsConnectionValid True 10:22:09 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:17 - IsConnectionValid True 10:22: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, Type AS Type, dbo.web_get_vacationCredit(ID,175,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 and Type = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:24 - IsConnectionValid True 10:22:24 - IsConnectionValid True 10:22:24 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:27 - IsConnectionValid True 10:22: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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:29 - IsConnectionValid True 10:22: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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 AND Name LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:30 - IsConnectionValid True 10:22:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:30 - IsConnectionValid True 10:22:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:36 - IsConnectionValid True 10:22:36 - IsConnectionValid True 10:22:36 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:38 - IsConnectionValid True 10:22: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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:40 - IsConnectionValid True 10:22: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, 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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 AND Name LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:22:41 - IsConnectionValid True 10:22:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:41 - IsConnectionValid True 10:22:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:22:49 - IsConnectionValid True 10:22: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, Type AS Type, dbo.web_get_vacationCredit(ID,175,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 and Type = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:23:06 - IsConnectionValid True 10:23:08 - IsConnectionValid True 10:23:08 - SELECT DISTINCT ID AS ID, FromDate AS FromDate, ToDate AS ToDate, Plus AS Plus, Minus AS Minus, EmployeeID AS EmployeeID, VacationType AS VacationType, VacationID AS VacationTypeID, Posted AS Posted, TypeScreen AS TypeScreen, ISNULL(Minus,0)-ISNULL(AvailableAmount,0) AS AvailableMinus, LeavingTypeName AS LeavingTypeName, FlagEffect AS FlagEffect FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND IsMonthPosted = @val4 ORDER BY FromDate ASC Query 10:23:10 - IsConnectionValid True 10:23:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:23:13 - IsConnectionValid True 10:23:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/19/2025)) and UserID = @val1 and TenantID = @val2 AND Name LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:23:15 - IsConnectionValid True 10:23: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, Type AS Type FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:23:16 - IsConnectionValid True 10:23:16 - SELECT DISTINCT ID AS ID, FromDate AS FromDate, ToDate AS ToDate, Plus AS Plus, Minus AS Minus, EmployeeID AS EmployeeID, VacationType AS VacationType, VacationID AS VacationTypeID, Posted AS Posted, TypeScreen AS TypeScreen, ISNULL(Minus,0)-ISNULL(AvailableAmount,0) AS AvailableMinus, LeavingTypeName AS LeavingTypeName, FlagEffect AS FlagEffect FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND IsMonthPosted = @val4 ORDER BY FromDate ASC Query 10:23:20 - IsConnectionValid True 10:23:20 - IsConnectionValid True 10:23:20 - SELECT DISTINCT ID AS ID, FromDate AS FromDate, ToDate AS ToDate, Plus AS Plus, Minus AS Minus, EmployeeID AS EmployeeID, VacationType AS VacationType, VacationID AS VacationTypeID, Posted AS Posted, TypeScreen AS TypeScreen, ISNULL(Minus,0)-ISNULL(AvailableAmount,0) AS AvailableMinus, LeavingTypeName AS LeavingTypeName, FlagEffect AS FlagEffect FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND IsMonthPosted = @val4 ORDER BY FromDate ASC Query 10:23:24 - IsConnectionValid True 10:35:54 - IsConnectionValid True 10:36:10 - IsConnectionValid True 10:36:54 - IsConnectionValid True 10:36:58 - IsConnectionValid True 10:37:03 - IsConnectionValid True 10:37:06 - IsConnectionValid True 10:37:22 - IsConnectionValid True 10:38:13 - IsConnectionValid True 10:40:38 - IsConnectionValid True 10:49:29 - IsConnectionValid True 10:49: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, 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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:49:39 - IsConnectionValid True 10:49:39 - 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 >06/19/2025)) and UserID = @val1 and TenantID = @val2 AND Name LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:49:41 - IsConnectionValid True 10:49:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:49:41 - IsConnectionValid True 10:49:41 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:49:45 - IsConnectionValid True