15:26:54 - IsConnectionValid True 15:27:05 - IsConnectionValid True 15:27:06 - IsConnectionValid True 15:27:08 - IsConnectionValid True 15:27:10 - IsConnectionValid True 15:27:11 - IsConnectionValid True 15:27:20 - IsConnectionValid True 15:27:20 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:27:57 - IsConnectionValid True 15:27:58 - IsConnectionValid True 15:27:58 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:57:14 - IsConnectionValid True 15:57:15 - IsConnectionValid True 15:57:15 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:59:57 - IsConnectionValid True 15:59:57 - IsConnectionValid True 15:59:57 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 22:10:44 - IsConnectionValid True 22:10:45 - IsConnectionValid True 22:10:45 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 22:57:28 - IsConnectionValid True 22:57:28 - IsConnectionValid True 22:57:28 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 22:58:34 - IsConnectionValid True 22:58:48 - IsConnectionValid True 22:58:49 - IsConnectionValid True 22:58:49 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:00:33 - IsConnectionValid True 23:00:34 - IsConnectionValid True 23:00:34 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:01:49 - IsConnectionValid True 23:01:49 - IsConnectionValid True 23:01:49 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:02:20 - IsConnectionValid True 23:02:21 - IsConnectionValid True 23:02:21 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:05:16 - IsConnectionValid True 23:05:16 - IsConnectionValid True 23:05:16 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:12:27 - IsConnectionValid True 23:12:28 - IsConnectionValid True 23:12:28 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:12:30 - IsConnectionValid True 23:12:30 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:12:31 - IsConnectionValid True 23:12:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:14:01 - IsConnectionValid True 23:14:02 - IsConnectionValid True 23:14:02 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:14:04 - IsConnectionValid True 23:14:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND DateLeft <> @val5 AND (Code LIKE '%1%' OR Name LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY Code ASC Query 23:14:04 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 23:14:05 - IsConnectionValid True 23:14:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND DateLeft <> @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:14:05 - (1-gen-1004) : Conversion failed when converting date and/or time from character string. 23:14:28 - IsConnectionValid True 23:14:28 - IsConnectionValid True 23:14:28 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:14:30 - IsConnectionValid True 23:14:30 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND (Code LIKE '%1%' OR Name LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY Code ASC Query 23:14:30 - IsConnectionValid True 23:14:30 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:15:00 - IsConnectionValid True 23:15:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND Code LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:15:12 - IsConnectionValid True 23:15:38 - IsConnectionValid True 23:15:39 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:17:24 - IsConnectionValid True 23:17:24 - IsConnectionValid True 23:17:24 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:17:26 - IsConnectionValid True 23:17:26 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND (Code LIKE '%1%' OR Name LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY Code ASC Query 23:17:26 - IsConnectionValid True 23:17:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:17:30 - IsConnectionValid True 23:17:30 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND EnglishName LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:17:41 - IsConnectionValid True 23:17:41 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:18:26 - IsConnectionValid True 23:18:26 - IsConnectionValid True 23:18:26 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:18:28 - IsConnectionValid True 23:18:28 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND (Code LIKE '%1%' OR Name LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY Code ASC Query 23:18:29 - IsConnectionValid True 23:18:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:18:32 - IsConnectionValid True 23:18:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND EnglishName LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:18:40 - IsConnectionValid True 23:18:40 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:19:20 - IsConnectionValid True 23:19:20 - IsConnectionValid True 23:19:20 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:21:35 - IsConnectionValid True 23:21:36 - IsConnectionValid True 23:21:36 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:21:41 - IsConnectionValid True 23:21:41 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND (Code LIKE '%1%' OR Name LIKE '%1%' OR EnglishName LIKE '%1%' ) ORDER BY Code ASC Query 23:21:41 - IsConnectionValid True 23:21:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:21:45 - IsConnectionValid True 23:21:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CAST(DateLeft AS Date) <> @val5 AND EnglishName LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:21:55 - IsConnectionValid True 23:21:55 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:22:41 - IsConnectionValid True 23:22:41 - IsConnectionValid True 23:22:41 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:22:43 - IsConnectionValid True 23:22:43 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:22:43 - IsConnectionValid True 23:22:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:22:47 - IsConnectionValid True 23:22:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:22:52 - IsConnectionValid True 23:22:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:22:54 - IsConnectionValid True 23:22:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:23:03 - IsConnectionValid True 23:23:03 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:25:28 - IsConnectionValid True 23:25:29 - IsConnectionValid True 23:25:29 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:25:33 - IsConnectionValid True 23:25:33 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:25:34 - IsConnectionValid True 23:25:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:25:39 - IsConnectionValid True 23:25:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:25:40 - IsConnectionValid True 23:25:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:25:43 - IsConnectionValid True 23:25:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:25:52 - IsConnectionValid True 23:26:06 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:27:00 - IsConnectionValid True 23:27:00 - IsConnectionValid True 23:27:00 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:27:13 - IsConnectionValid True 23:27:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:27:13 - IsConnectionValid True 23:27:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:27:16 - IsConnectionValid True 23:27:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:27:20 - IsConnectionValid True 23:27:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:27:29 - IsConnectionValid True 23:27:29 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:28:48 - IsConnectionValid True 23:28:49 - IsConnectionValid True 23:28:49 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:29:04 - IsConnectionValid True 23:29:04 - IsConnectionValid True 23:29:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:29:04 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:29:05 - IsConnectionValid True 23:29:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:29:05 - IsConnectionValid True 23:29:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:29:10 - IsConnectionValid True 23:29:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:29:14 - IsConnectionValid True 23:29:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:29:33 - IsConnectionValid True 23:29:34 - IsConnectionValid True 23:29:34 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:29:37 - IsConnectionValid True 23:29:50 - IsConnectionValid True 23:29:50 - IsConnectionValid True 23:30:06 - IsConnectionValid True 23:30:06 - IsConnectionValid True 23:30:06 - IsConnectionValid True 23:30:06 - SELECT DISTINCT * FROM StaffCategory WHERE TenantID =1 ORDER BY ID Query 23:30:06 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC Query 23:30:08 - IsConnectionValid True 23:30:19 - IsConnectionValid True 23:30:19 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:30:28 - IsConnectionValid True 23:30:28 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:30:29 - IsConnectionValid True 23:30:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:30:32 - IsConnectionValid True 23:30:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:30:35 - IsConnectionValid True 23:30:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:30:38 - IsConnectionValid True 23:31:22 - (2-payroll-0010017) : Error converting data type varchar to numeric. 23:31:27 - IsConnectionValid True 23:31:27 - IsConnectionValid True 23:31:27 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:31:29 - IsConnectionValid True 23:31:29 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:31:29 - IsConnectionValid True 23:31:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:31:35 - IsConnectionValid True 23:31:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:31:44 - IsConnectionValid True 23:32:03 - IsConnectionValid True 23:32:03 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 23:32:35 - IsConnectionValid True 23:32:36 - IsConnectionValid True 23:32:36 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:32:37 - IsConnectionValid True 23:32:37 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:32:37 - IsConnectionValid True 23:32:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:32:43 - IsConnectionValid True 23:32:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:32:47 - IsConnectionValid True 23:32:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:32:55 - IsConnectionValid True 23:33:00 - IsConnectionValid True 23:33:00 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 23:34:20 - IsConnectionValid True 23:34:21 - IsConnectionValid True 23:34:21 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:34:22 - IsConnectionValid True 23:34:22 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:34:23 - IsConnectionValid True 23:34:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:34:29 - IsConnectionValid True 23:34:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:34:36 - IsConnectionValid True 23:34:44 - IsConnectionValid True 23:34:44 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 23:38:50 - IsConnectionValid True 23:38:50 - IsConnectionValid True 23:38:50 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:38:52 - IsConnectionValid True 23:38:52 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:38:52 - IsConnectionValid True 23:38:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:39:00 - IsConnectionValid True 23:39:00 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:39:07 - IsConnectionValid True 23:39:31 - IsConnectionValid True 23:39:32 - IsConnectionValid True 23:39:32 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:39:35 - IsConnectionValid True 23:39:35 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:39:35 - IsConnectionValid True 23:39:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:39:42 - IsConnectionValid True 23:39:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:39:50 - IsConnectionValid True 23:41:04 - IsConnectionValid True 23:41:11 - IsConnectionValid True 23:41:12 - IsConnectionValid True 23:41:12 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:41:13 - IsConnectionValid True 23:41:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:41:13 - IsConnectionValid True 23:41:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:41:25 - IsConnectionValid True 23:41:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:41:34 - IsConnectionValid True 23:46:10 - IsConnectionValid True 23:46:11 - IsConnectionValid True 23:46:11 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:46:13 - IsConnectionValid True 23:46:13 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:46:13 - IsConnectionValid True 23:46:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:46:19 - IsConnectionValid True 23:46:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:46:26 - IsConnectionValid True 23:46:35 - IsConnectionValid True 23:46:37 - IsConnectionValid True 23:46:37 - IsConnectionValid True 23:46:37 - IsConnectionValid True 23:47:33 - IsConnectionValid True 23:47:33 - IsConnectionValid True 23:47:34 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:47:42 - IsConnectionValid True 23:47:42 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:47:42 - IsConnectionValid True 23:47:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:47:46 - IsConnectionValid True 23:47:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:47:50 - IsConnectionValid True 23:47:50 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:47:53 - IsConnectionValid True 23:48:16 - IsConnectionValid True 23:48:16 - IsConnectionValid True 23:48:16 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:48:20 - IsConnectionValid True 23:48:20 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:48:20 - IsConnectionValid True 23:48:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:48:23 - IsConnectionValid True 23:48:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:48:27 - IsConnectionValid True 23:48:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:48:34 - IsConnectionValid True 23:49:22 - IsConnectionValid True 23:49:23 - IsConnectionValid True 23:49:23 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:49:25 - IsConnectionValid True 23:49:25 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:49:25 - IsConnectionValid True 23:49:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:49:33 - IsConnectionValid True 23:49:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:49:40 - IsConnectionValid True 23:51:03 - IsConnectionValid True 23:51:03 - IsConnectionValid True 23:51:03 - SELECT DISTINCT ID AS ID, MonthCode AS Code, YEAR(FromDate) AS YearNo, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 23:51:07 - IsConnectionValid True 23:51:08 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY Code ASC Query 23:51:08 - IsConnectionValid True 23:51:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:51:10 - IsConnectionValid True 23:51:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:51:14 - IsConnectionValid True 23:51:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND EnglishName LIKE @val5 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val6 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 23:51:25 - IsConnectionValid True 23:51:28 - IsConnectionValid True 23:54:28 - IsConnectionValid True 23:54:31 - IsConnectionValid True