11:53:15 - 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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:53:23 - 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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:53:30 - 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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:55:00 - 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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:55:55 - 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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow