13:44:35 - 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 13:44:41 - 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 13:44:58 - 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 13:45: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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:45:05 - 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 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:45:13 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:48: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 13:48:22 - 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 13:48:26 - 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 AND IsSalaryDetails = @val9 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:48:31 - (3-hr-0010001) : Error converting data type varchar to numeric. 14:06:40 - 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 14:11:08 - 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 14:11: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 (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2 AND DateLeftTemp LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:12: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 14:12:03 - 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 DateLeftTemp LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:12:07 - 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 14:13:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:13:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND DateLeftTemp LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:13:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:17:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:17:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND DateLeftTemp LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:18: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:20: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:23:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:23: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:23:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:25:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:25:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:26:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:26:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN true ELSE false END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:26:40 - (1-gen-1004) : Invalid column name 'true'. Invalid column name 'false'. 14:27:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:27:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:27:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:27:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:27:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:27:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:28:56 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:28:58 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:30:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:30:14 - 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 14:30:18 - 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 14:30:21 - 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 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:30: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 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:30:24 - 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 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:31:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND and UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:31:18 - (1-gen-1004) : Incorrect syntax near the keyword 'and'. 14:32:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:32:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:32:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:32:24 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:32:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:32:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:32:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:33:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:33:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:33: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE 'false' END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:33:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:33:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:34:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:34:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:35:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:36:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:36:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:36:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:36:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:36:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:36:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:36:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else '' end END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:36:58 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else '' end END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:37:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:37:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:37:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:37:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:42:58 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:43:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:43:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else 'ddddddddd' end END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else 'ddddddddd' end END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:43:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:43:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else 'ddddddddd' end END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:44:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:44: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:44:24 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:44:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:44:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:44:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 14:45:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:45:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:16:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:16: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:17:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 15:17:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND DateLeftTemp LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:17:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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 15:18: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 TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:19:33 - 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 15:19:38 - 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 15:19:41 - 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 AND DateLeftTemp LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:01 - 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 15:23:08 - 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 15:23: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 AND Code LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:19 - 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 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 'true' ELSE CASE WHEN DateLeftTemp='01/01/1900' then 'false' else 'ddddddddd' end END LIKE @val4 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:26:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * 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