13:39:24 - IsConnectionValid True 13:39:27 - IsConnectionValid True 13:39:28 - IsConnectionValid True 13:39:35 - IsConnectionValid True 13:39:35 - IsConnectionValid True 13:39:40 - IsConnectionValid True 13:39:44 - IsConnectionValid True 13:39:44 - 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' ) @val3 AND (Code LIKE '%1%' OR Name LIKE '%1%' ) ORDER BY ID ASC Query 13:39:44 - (1-gen-1002) : Incorrect syntax near '@val3'. 13:39:45 - IsConnectionValid True 13:39: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 TenantID = 1 AND 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' ) @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:39:45 - (1-gen-1004) : Incorrect syntax near '@val3'. 13:39:54 - IsConnectionValid True 13:39: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' ) @val3 AND (Code LIKE '%1%' OR Name LIKE '%1%' ) ORDER BY ID ASC Query 13:39:54 - (1-gen-1002) : Incorrect syntax near '@val3'. 13:39:54 - IsConnectionValid True 13:39: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 TenantID = 1 AND 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' ) @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:39:54 - (1-gen-1004) : Incorrect syntax near '@val3'. 13:41:36 - IsConnectionValid True 13:41:41 - IsConnectionValid True 13:41: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 @val3 AND (Code LIKE '%1%' OR Name LIKE '%1%' ) ORDER BY ID ASC Query 13:41:41 - (1-gen-1002) : Incorrect syntax near '@val3'. 13:41:41 - IsConnectionValid True 13:41: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 TenantID = 1 AND UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:41:41 - (1-gen-1004) : Incorrect syntax near '@val3'. 13:41:58 - IsConnectionValid True 13:42:03 - IsConnectionValid True 13:42:03 - 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:42:04 - IsConnectionValid True 13:42: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 13:53:23 - IsConnectionValid True 13:53:38 - IsConnectionValid True 13:53:44 - IsConnectionValid True 13:53:46 - IsConnectionValid True 13:53:46 - IsConnectionValid True 13:53:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 13:53:46 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:53:46 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 13:53:48 - IsConnectionValid True 13:54:00 - IsConnectionValid True 13:54:00 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:55:19 - IsConnectionValid True 14:35:51 - IsConnectionValid True 14:35:55 - IsConnectionValid True 14:35:55 - IsConnectionValid True 14:35:55 - IsConnectionValid True 14:35:55 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:35:55 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 14:35:55 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 14:35:58 - IsConnectionValid True 14:58:26 - IsConnectionValid True 14:59:14 - IsConnectionValid True 14:59:44 - IsConnectionValid True 15:00:43 - IsConnectionValid True 15:00:49 - IsConnectionValid True 15:00: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 15:00:49 - IsConnectionValid True 15:00: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 15:00:52 - IsConnectionValid True 15:00: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 15:00:53 - IsConnectionValid True 15:00:53 - (399-pay-00100099) : ExecuteReader: CommandText property has not been initialized 15:01:50 - IsConnectionValid True 15:01:57 - IsConnectionValid True 15:01: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 15:01:57 - IsConnectionValid True 15:01: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 15:01:59 - IsConnectionValid True 15:01: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 15:02:00 - IsConnectionValid True 15:02:00 - (399-pay-00100099) : ExecuteReader: CommandText property has not been initialized 15:03:46 - IsConnectionValid True 15:03:46 - 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 15:03:47 - IsConnectionValid True 15:03:47 - (399-pay-00100099) : ExecuteReader: CommandText property has not been initialized 15:04:38 - IsConnectionValid True 15:04:47 - IsConnectionValid True 15:04: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 15:04:47 - IsConnectionValid True 15:04: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 15:04:49 - IsConnectionValid True 15:04: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 15:04:51 - IsConnectionValid True 15:04:51 - (399-pay-00100099) : MonthID 15:05:12 - IsConnectionValid True 15:05:12 - 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 15:05:12 - IsConnectionValid True