12:36:05 - IsConnectionValid True
12:36:06 - IsConnectionValid True
12:36:21 - IsConnectionValid True
12:36:22 - IsConnectionValid True
12:36:26 - IsConnectionValid True
12:36:30 - IsConnectionValid True
12:36:53 - IsConnectionValid True
12:51:51 - IsConnectionValid True
12:52:16 - IsConnectionValid True
12:52:19 - IsConnectionValid True
12:52:41 - IsConnectionValid True
12:52: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
12:52:42 - IsConnectionValid True
12:52:42 - 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:52:44 - IsConnectionValid True
12:52:44 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry L LEFT OUTER JOIN Close  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or (Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID)))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:52:44 - (1-gen-1004) : Incorrect syntax near the keyword 'Close'.
Incorrect syntax near ')'.
12:53:49 - IsConnectionValid True
12:53:55 - IsConnectionValid True
12:53:55 - 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:53:55 - IsConnectionValid True
12:53:55 - 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:53:58 - IsConnectionValid True
12:53:58 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or (Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID)))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:53:58 - (1-gen-1004) : Incorrect syntax near ')'.
12:55:54 - IsConnectionValid True
12:55:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or (Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID)))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:55:54 - (1-gen-1004) : Incorrect syntax near ')'.
12:55:57 - IsConnectionValid True
12:56:04 - IsConnectionValid True
12:56:04 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:56:05 - IsConnectionValid True
12:56: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
12:56:06 - IsConnectionValid True
12:56: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
12:56:08 - IsConnectionValid True
12:56:08 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:56:16 - IsConnectionValid True
12:56:16 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:56:18 - IsConnectionValid True
12:56:18 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:56:22 - IsConnectionValid True
12:56:22 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:57:12 - IsConnectionValid True
12:57:17 - IsConnectionValid True
12:58:18 - IsConnectionValid True