10:50:37 - IsConnectionValid True 10:50:43 - IsConnectionValid True 10:50:44 - IsConnectionValid True 10:50:59 - IsConnectionValid True 10:51:00 - IsConnectionValid True 10:51:04 - IsConnectionValid True 10:51:08 - IsConnectionValid True 10:51:10 - IsConnectionValid True 10:51:14 - IsConnectionValid True 10:51:14 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 10:51:14 - IsConnectionValid True 10:51:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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:51:16 - IsConnectionValid True 10:51:16 - 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:51:18 - IsConnectionValid True 10:51:20 - IsConnectionValid True 10:51:20 - 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:51:21 - IsConnectionValid True 10:58:58 - IsConnectionValid True 10:58:58 - 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:59:01 - IsConnectionValid True 10:59:01 - 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:59:09 - IsConnectionValid True 10:59:14 - IsConnectionValid True 10:59:14 - 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 11:00:13 - IsConnectionValid True 11:00:15 - IsConnectionValid True 11:00:15 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:00:15 - IsConnectionValid True 11:00:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:00:21 - IsConnectionValid True 11:00:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:00:23 - IsConnectionValid True 11:00:23 - 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 11:00:26 - IsConnectionValid True 11:00:27 - IsConnectionValid True 11:00:27 - 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 11:00:56 - IsConnectionValid True 11:01:15 - IsConnectionValid True 11:01:20 - IsConnectionValid True 11:01:20 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:01:21 - IsConnectionValid True 11:01:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:01:23 - IsConnectionValid True 11:01:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:01:24 - IsConnectionValid True 11:01:24 - 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 11:01:25 - IsConnectionValid True 11:02:13 - IsConnectionValid True 11:02: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 11:02:14 - IsConnectionValid True 11:02:24 - IsConnectionValid True 11:02:33 - IsConnectionValid True 11:02:33 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:02:33 - IsConnectionValid True 11:02:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:02:36 - IsConnectionValid True 11:02:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:02:38 - IsConnectionValid True 11:02:38 - 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 11:02:39 - IsConnectionValid True 11:08:28 - IsConnectionValid True 11:08:28 - 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 11:13:34 - IsConnectionValid True 11:13:36 - IsConnectionValid True 11:13:40 - IsConnectionValid True 11:13:40 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:13:41 - IsConnectionValid True 11:13:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:13:45 - IsConnectionValid True 11:13: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, Name 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 11:13:47 - IsConnectionValid True 11:13:47 - 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 11:13:48 - IsConnectionValid True 11:14:57 - IsConnectionValid True 11:15:01 - IsConnectionValid True 11:15:01 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:15:02 - IsConnectionValid True 11:15:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:15:05 - IsConnectionValid True 11:15:05 - 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 11:15:07 - IsConnectionValid True 11:15:35 - IsConnectionValid True 11:15:39 - IsConnectionValid True 11:15:39 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:15:40 - IsConnectionValid True 11:15:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:15:41 - IsConnectionValid True 11:15:41 - 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 11:15:42 - IsConnectionValid True 11:17:00 - IsConnectionValid True 11:17:04 - IsConnectionValid True 11:17:04 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:17:04 - IsConnectionValid True 11:17:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:17:06 - IsConnectionValid True 11:17:06 - 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 11:17:07 - IsConnectionValid True 11:20:58 - IsConnectionValid True 11:21:02 - IsConnectionValid True 11:21:02 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:21:05 - IsConnectionValid True 11:21:05 - IsConnectionValid True 11:21:05 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:21:05 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:21:05 - IsConnectionValid True 11:21:06 - IsConnectionValid True 11:21:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:21:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:21:06 - IsConnectionValid True 11:21: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, Name 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 11:21:09 - IsConnectionValid True 11:21:09 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:21:09 - IsConnectionValid True 11:21:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:21:11 - IsConnectionValid True 11:21:11 - 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 11:21:12 - IsConnectionValid True 11:23:34 - IsConnectionValid True 11:23:40 - IsConnectionValid True 11:23:40 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:23:41 - IsConnectionValid True 11:23:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:23:44 - IsConnectionValid True 11:23:44 - 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 11:23:44 - IsConnectionValid True 11:24:19 - IsConnectionValid True 11:24:28 - IsConnectionValid True 11:24:28 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:24:29 - IsConnectionValid True 11:24:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:24:32 - IsConnectionValid True 11:24:32 - 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 11:24:32 - IsConnectionValid True 11:24:59 - IsConnectionValid True 11:25:06 - IsConnectionValid True 11:25:06 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:25:07 - IsConnectionValid True 11:25: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, Name 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 11:25:09 - IsConnectionValid True 11:25:09 - 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 11:25:10 - IsConnectionValid True 11:25:41 - IsConnectionValid True 11:25:49 - IsConnectionValid True 11:25:49 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:25:49 - IsConnectionValid True 11:25:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:25:52 - IsConnectionValid True 11:25:52 - 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 11:25:53 - IsConnectionValid True 11:27:15 - IsConnectionValid True 11:27:25 - IsConnectionValid True 11:27:25 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:27:26 - IsConnectionValid True 11:27:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:27:30 - IsConnectionValid True 11:27:30 - 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 11:27:31 - IsConnectionValid True 11:28:37 - IsConnectionValid True 11:28:45 - IsConnectionValid True 11:28:45 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:28:46 - IsConnectionValid True 11:28:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:28:48 - IsConnectionValid True 11:28:48 - 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 11:28:49 - IsConnectionValid True 11:30:33 - IsConnectionValid True 11:30:39 - IsConnectionValid True 11:30:39 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:30:40 - IsConnectionValid True 11:30:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:30:42 - IsConnectionValid True 11:30:42 - 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 11:30:43 - IsConnectionValid True 11:31:27 - IsConnectionValid True 11:31:32 - IsConnectionValid True 11:31:32 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:31:32 - IsConnectionValid True 11:31:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:31:35 - IsConnectionValid True 11:31:35 - 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 11:31:36 - IsConnectionValid True 11:36:51 - IsConnectionValid True 11:36:57 - IsConnectionValid True 11:36:57 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:36:57 - IsConnectionValid True 11:36:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:36:59 - IsConnectionValid True 11:36:59 - 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 11:37:00 - IsConnectionValid True 11:37:41 - IsConnectionValid True 11:37:45 - IsConnectionValid True 11:37:45 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:37:45 - IsConnectionValid True 11:37: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, Name 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 11:37:47 - IsConnectionValid True 11:37:47 - 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 11:37:48 - IsConnectionValid True 11:40:57 - IsConnectionValid True 11:41:02 - IsConnectionValid True 11:41:02 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:41:02 - IsConnectionValid True 11:41:02 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:41:04 - IsConnectionValid True 11:41:04 - 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 11:41:04 - IsConnectionValid True 11:48:07 - IsConnectionValid True 11:48:12 - IsConnectionValid True 11:48:12 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:48:13 - IsConnectionValid True 11:48:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:48:14 - IsConnectionValid True 11:48:14 - 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 11:48:15 - IsConnectionValid True 11:49:36 - IsConnectionValid True 11:49:40 - IsConnectionValid True 11:49:40 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:49:41 - IsConnectionValid True 11:49:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:49:42 - IsConnectionValid True 11:49:43 - 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 11:49:43 - IsConnectionValid True 11:51:32 - IsConnectionValid True 11:51:36 - IsConnectionValid True 11:51:36 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:51:36 - IsConnectionValid True 11:51:36 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:51:38 - IsConnectionValid True 11:51:38 - 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 11:51:39 - IsConnectionValid True 11:51:39 - 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 11:51:39 - IsConnectionValid True 11:52:34 - IsConnectionValid True 11:52:39 - IsConnectionValid True 11:52:39 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:52:39 - IsConnectionValid True 11:52:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:52:41 - IsConnectionValid True 11:52:41 - 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 11:52:41 - IsConnectionValid True 11:54:03 - IsConnectionValid True 11:54:06 - IsConnectionValid True 11:54:06 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:54:06 - IsConnectionValid True 11:54:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:54:08 - IsConnectionValid True 11:54:08 - 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 11:54:09 - IsConnectionValid True 11:58:37 - IsConnectionValid True 11:58:41 - IsConnectionValid True 11:58:41 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 11:58:41 - IsConnectionValid True 11:58:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 11:58:43 - IsConnectionValid True 11:58:43 - 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 11:58:44 - IsConnectionValid True 12:02:21 - IsConnectionValid True 12:02:25 - IsConnectionValid True 12:03:31 - IsConnectionValid True 12:03:58 - IsConnectionValid True 12:04:25 - IsConnectionValid True 12:04:32 - IsConnectionValid True 12:05:59 - IsConnectionValid True 12:06:03 - IsConnectionValid True 12:09:35 - IsConnectionValid True 12:09:41 - IsConnectionValid True 12:09:55 - IsConnectionValid True 12:10:13 - IsConnectionValid True 12:10:13 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:10:13 - IsConnectionValid True 12:10:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:10:16 - IsConnectionValid True 12:10:16 - 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 12:10:16 - IsConnectionValid True 12:10:42 - IsConnectionValid True 12:10:47 - IsConnectionValid True 12:10:47 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:10:47 - IsConnectionValid True 12:10:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:10:49 - IsConnectionValid True 12:10:49 - 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 12:10:50 - IsConnectionValid True 12:12:48 - IsConnectionValid True 12:12:54 - IsConnectionValid True 12:12:54 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:12:54 - IsConnectionValid True 12:12:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:12:56 - IsConnectionValid True 12:12: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 12:12:56 - IsConnectionValid True 12:54:19 - IsConnectionValid True 12:54:36 - IsConnectionValid True 12:54:36 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:54:37 - IsConnectionValid True 12:54:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:54:40 - IsConnectionValid True 12:54: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 12:54:41 - IsConnectionValid True 12:55:45 - IsConnectionValid True 12:56:40 - IsConnectionValid True 12:56:48 - IsConnectionValid True 12:56:48 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:56:48 - IsConnectionValid True 12:56:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:56:50 - IsConnectionValid True 12:56:50 - 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 12:56:51 - IsConnectionValid True 12:57:04 - IsConnectionValid True 12:57:05 - IsConnectionValid True 12:57:51 - IsConnectionValid True 12:57:51 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:57:53 - IsConnectionValid True 12:58:00 - IsConnectionValid True 12:58:00 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:58:01 - IsConnectionValid True 12:58:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:58:03 - IsConnectionValid True 12:58:03 - 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 12:58:04 - IsConnectionValid True 12:58:09 - IsConnectionValid True 12:58:10 - IsConnectionValid True 12:58:12 - IsConnectionValid True 12:58:12 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 12:58:13 - IsConnectionValid True 12:58:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 12:58:16 - IsConnectionValid True 12:58:16 - 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 12:58:17 - IsConnectionValid True 13:00:24 - IsConnectionValid True 13:00:24 - 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 13:00:24 - IsConnectionValid True 13:00:29 - IsConnectionValid True 13:00:29 - IsConnectionValid True 13:00:31 - IsConnectionValid True 13:00:31 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 13:00:31 - IsConnectionValid True 13:00:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 13:00:33 - IsConnectionValid True 13:00:33 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 13:00:34 - IsConnectionValid True 13:00:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 13:00:36 - IsConnectionValid True 13:00:36 - 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 13:00:37 - IsConnectionValid True 13:00:43 - IsConnectionValid True 13:00:44 - IsConnectionValid True 13:00:46 - IsConnectionValid True 13:00:46 - SELECT ID AS ID, Code AS Code, Name 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 Name LIKE '%1%' ) ORDER BY ID ASC Query 13:00:46 - IsConnectionValid True 13:00:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 13:00:51 - IsConnectionValid True 13:00:51 - 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 13:00:51 - IsConnectionValid True 13:01:36 - IsConnectionValid True 13:04:01 - IsConnectionValid True 14:21:28 - IsConnectionValid True 14:21:41 - IsConnectionValid True 14:22:30 - IsConnectionValid True 14:22:38 - IsConnectionValid True