10:31:56 - IsConnectionValid True
10:31:57 - IsConnectionValid True
10:32:01 - IsConnectionValid True
10:32:01 - IsConnectionValid True
10:32:04 - IsConnectionValid True
10:32:04 - IsConnectionValid True
10:32:07 - IsConnectionValid True
10:32:07 - SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID IN (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND (Code LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY ID ASC  Query
10:32:07 - IsConnectionValid True
10:32:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc')  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:10 - IsConnectionValid True
10:32:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND Code LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:13 - IsConnectionValid True
10:32:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionForSalCal  WHERE   TenantID = @val0 AND (Reccuring=99 or Reccuring=2)  AND IsNotManualEntry = @val2 AND Loans = @val3 AND EmployeeID = @val4 AND UserID = @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:14 - IsConnectionValid True
10:32:18 - IsConnectionValid True
10:32:40 - IsConnectionValid True
10:32:40 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionForSalCal  WHERE   TenantID = @val0 AND (Reccuring=99 or Reccuring=2)  AND IsNotManualEntry = @val2 AND Loans = @val3 AND EmployeeID = @val4 AND UserID = @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:41 - IsConnectionValid True
10:32:44 - IsConnectionValid True
10:32:44 - SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID IN (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND (Code LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY ID ASC  Query
10:32:44 - IsConnectionValid True
10:32:44 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc')  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:45 - IsConnectionValid True
10:32:45 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND Code LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:52 - IsConnectionValid True
10:32:52 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND Code LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:56 - IsConnectionValid True
10:32:56 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionForSalCal  WHERE   TenantID = @val0 AND (Reccuring=99 or Reccuring=2)  AND IsNotManualEntry = @val2 AND Loans = @val3 AND EmployeeID = @val4 AND UserID = @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:32:57 - IsConnectionValid True
10:33:03 - IsConnectionValid True
10:33:05 - IsConnectionValid True
10:33:05 - SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID IN (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND (Code LIKE '%1%'  OR EnglishName LIKE '%1%' ) ORDER BY ID ASC  Query
10:33:05 - IsConnectionValid True
10:33:05 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc')  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:33:07 - IsConnectionValid True
10:33:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, EnglishName AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND Code LIKE @val4  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:33:10 - IsConnectionValid True
10:33:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionForSalCal  WHERE   TenantID = @val0 AND (Reccuring=99 or Reccuring=2)  AND IsNotManualEntry = @val2 AND Loans = @val3 AND EmployeeID = @val4 AND UserID = @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:33:11 - IsConnectionValid True
10:33:31 - IsConnectionValid True
10:33:40 - IsConnectionValid True