10:47:16 - IsConnectionValid True
10:47:16 - IsConnectionValid True
10:47:21 - IsConnectionValid True
10:47:21 - IsConnectionValid True
10:47:24 - IsConnectionValid True
10:47:29 - IsConnectionValid True
10:47:29 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT * FROM EmpWifeInfo WHERE  TenantID =1 and EmpId = @val1 ORDER BY Code  Query
10:47:30 - SELECT  DISTINCT * FROM Section WHERE TenantID = 1 AND   TenantID = @val0 and ID = @val1  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE  TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate))   Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM Nation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT * FROM vwEmployeeLanguages WHERE  TenantID =1 and EmployeeID = @val1  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM EducationCity WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM Countries WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM JobType WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE  TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM Conservatism WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM Subjects WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM JobDegree WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM VwEmpEducations WHERE  TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - SELECT  DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - SELECT  DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:30 - IsConnectionValid True
10:47:30 - IsConnectionValid True
10:47:31 - IsConnectionValid True
10:47:31 - SELECT  DISTINCT * FROM Banks WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:47:31 - SELECT  DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE  Emp.TenantID =1 AND Emp.EmpID =877  Query
10:47:31 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 877 WHERE  CustodyItemsDef.TenantID =1  Query
10:47:31 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 877 WHERE  LocationDef.TenantID =1  Query
10:47:31 - IsConnectionValid True
10:47:31 - SELECT * FROM vwEmpDocumentDet WHERE  TenantID =1 and EmpID = @val1 ORDER BY ID  Query
10:47:31 - IsConnectionValid True
10:47:31 - SELECT * FROM vwCoursesEntryDetails WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:47:31 - IsConnectionValid True
10:47:31 - IsConnectionValid True
10:47:31 - SELECT * FROM vwThanksBooksEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:47:31 - SELECT * FROM vwInjuryEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:47:31 - SELECT * FROM vwWarningEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
10:47:31 - IsConnectionValid True
10:47:31 - IsConnectionValid True
10:47:31 - SELECT  DISTINCT * FROM Departments WHERE  TenantID =1 and ID = @val1  Query
10:47:31 - IsConnectionValid True
10:47:31 - SELECT  DISTINCT * FROM Section WHERE  TenantID =1 and ID = @val1  Query
11:14:10 - IsConnectionValid True
11:14:22 - IsConnectionValid True
11:14:24 - IsConnectionValid True
12:14:38 - IsConnectionValid True
12:14:38 - IsConnectionValid True
12:14:53 - IsConnectionValid True
12:16:54 - IsConnectionValid True
12:16:55 - IsConnectionValid True
12:17:11 - IsConnectionValid True
12:17:11 - 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 FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:17:13 - IsConnectionValid True
12:17: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 FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:17:15 - IsConnectionValid True
12:17:59 - IsConnectionValid True
12:18:19 - IsConnectionValid True
12:18:21 - IsConnectionValid True
12:18:21 - IsConnectionValid True
12:18:21 - IsConnectionValid True
12:18:21 - IsConnectionValid True
12:18:24 - IsConnectionValid True
12:19:01 - IsConnectionValid True
12:19:02 - IsConnectionValid True
12:19:02 - IsConnectionValid True
12:19:02 - IsConnectionValid True
12:19:02 - IsConnectionValid True
12:19:17 - IsConnectionValid True
12:19:17 - IsConnectionValid True
12:19:17 - IsConnectionValid True
12:19:17 - IsConnectionValid True
12:19:18 - IsConnectionValid True
12:19:18 - 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 FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:19:25 - IsConnectionValid True
12:20:37 - IsConnectionValid True
12:20: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 FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:20:40 - IsConnectionValid True
12:20: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 FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:20:42 - IsConnectionValid True
12:24:53 - IsConnectionValid True
12:24:54 - IsConnectionValid True
12:24:54 - IsConnectionValid True
12:25:13 - IsConnectionValid True
12:25:13 - IsConnectionValid True
12:25:14 - IsConnectionValid True
12:25:14 - IsConnectionValid True
12:25:14 - IsConnectionValid True
12:27:41 - IsConnectionValid True
12:27:42 - IsConnectionValid True
12:27:42 - IsConnectionValid True
12:32:59 - IsConnectionValid True
12:32:59 - IsConnectionValid True
12:32:59 - IsConnectionValid True
12:33:00 - IsConnectionValid True
12:33:00 - IsConnectionValid True
12:33:00 - IsConnectionValid True
12:33:00 - IsConnectionValid True
13:26:47 - IsConnectionValid True
13:26:59 - IsConnectionValid True
13:26:59 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
13:26:59 - IsConnectionValid True
13:26:59 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:02 - IsConnectionValid True
13:27:02 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:15 - IsConnectionValid True
13:27:20 - IsConnectionValid True
13:27:20 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:24 - IsConnectionValid True
13:27:24 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:29 - IsConnectionValid True
13:27:29 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:31 - IsConnectionValid True
13:27:31 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:35 - IsConnectionValid True
13:27:38 - IsConnectionValid True
13:27:40 - IsConnectionValid True
13:27:44 - IsConnectionValid True
13:27:44 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM EmpWifeInfo WHERE  TenantID =1 and EmpId = @val1 ORDER BY Code  Query
13:27:46 - SELECT  DISTINCT * FROM Section WHERE TenantID = 1 AND   TenantID = @val0 and ID = @val1  Query
13:27:46 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE  TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate))   Query
13:27:46 - SELECT  DISTINCT * FROM Jobs WHERE  TenantID =1 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM Projects WHERE  TenantID =1 and ID = @val1  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Nation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT * FROM vwEmployeeLanguages WHERE  TenantID =1 and EmployeeID = @val1  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Conservatism WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM EducationCity WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM JobType WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Countries WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE  TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Subjects WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM JobDegree WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM VwEmpEducations WHERE  TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
13:27:46 - SELECT  DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Banks WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM vwEmpDocumentDet WHERE  TenantID =1 and EmpID = @val1 ORDER BY ID  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
13:27:46 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 877 WHERE  LocationDef.TenantID =1  Query
13:27:46 - IsConnectionValid True
13:27:46 - IsConnectionValid True
13:27:46 - SELECT  DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE  Emp.TenantID =1 AND Emp.EmpID =877  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 877 WHERE  CustodyItemsDef.TenantID =1  Query
13:27:46 - SELECT * FROM vwCoursesEntryDetails WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM vwThanksBooksEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM vwWarningEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
13:27:46 - IsConnectionValid True
13:27:46 - SELECT * FROM vwInjuryEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
13:27:47 - IsConnectionValid True
13:27:47 - IsConnectionValid True
13:27:47 - SELECT  DISTINCT * FROM Departments WHERE  TenantID =1 and ID = @val1  Query
13:27:47 - IsConnectionValid True
13:27:47 - SELECT  DISTINCT * FROM Section WHERE  TenantID =1 and ID = @val1  Query
13:27:50 - IsConnectionValid True
13:27:50 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:53 - IsConnectionValid True
13:27:56 - IsConnectionValid True
13:27:56 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:56 - IsConnectionValid True
13:27:56 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:27:59 - IsConnectionValid True
13:27:59 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:18 - IsConnectionValid True
13:28:18 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
13:28:18 - IsConnectionValid True
13:28:19 - IsConnectionValid True
13:28:19 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:19 - IsConnectionValid True
13:28:19 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:23 - IsConnectionValid True
13:28:28 - IsConnectionValid True
13:28:28 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:43 - IsConnectionValid True
13:28:43 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
13:28:43 - IsConnectionValid True
13:28:43 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:45 - IsConnectionValid True
13:28:45 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:51 - IsConnectionValid True
13:28:54 - IsConnectionValid True
13:28:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:28:55 - IsConnectionValid True
13:28:55 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:06 - IsConnectionValid True
13:29:06 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
13:29:06 - IsConnectionValid True
13:29:06 - IsConnectionValid True
13:29:06 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:07 - IsConnectionValid True
13:29:07 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:12 - IsConnectionValid True
13:29:12 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
13:29:12 - IsConnectionValid True
13:29:12 - IsConnectionValid True
13:29:12 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:13 - IsConnectionValid True
13:29:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:53 - IsConnectionValid True
13:29:53 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
13:29:53 - IsConnectionValid True
13:29:53 - IsConnectionValid True
13:29:53 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:54 - IsConnectionValid True
13:29:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:29 - IsConnectionValid True
13:30:29 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:29 - IsConnectionValid True
13:30:29 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:30 - IsConnectionValid True
13:30:32 - IsConnectionValid True
13:30:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:33 - IsConnectionValid True
13:30:33 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:41 - IsConnectionValid True
13:30:46 - IsConnectionValid True
13:30:46 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
13:30:46 - IsConnectionValid True
13:30: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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:49 - IsConnectionValid True
13:30:49 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:31:42 - IsConnectionValid True
13:32:43 - IsConnectionValid True
13:32:45 - IsConnectionValid True
13:37:06 - IsConnectionValid True
13:39:04 - IsConnectionValid True
13:39:08 - IsConnectionValid True
13:39:08 - IsConnectionValid True
13:39:08 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:39:13 - IsConnectionValid True
13:39:14 - IsConnectionValid True
13:39:18 - IsConnectionValid True
13:39:18 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
13:39:18 - IsConnectionValid True
13:39:18 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:39:23 - IsConnectionValid True
13:39:23 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:39:37 - IsConnectionValid True
13:40:05 - IsConnectionValid True
13:40:13 - IsConnectionValid True
13:41:07 - IsConnectionValid True
13:41:12 - IsConnectionValid True
13:41:18 - IsConnectionValid True
13:41:18 - IsConnectionValid True
13:41:18 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:41:21 - IsConnectionValid True
13:41:21 - IsConnectionValid True
13:41:21 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:41:28 - IsConnectionValid True
13:41:28 - IsConnectionValid True
13:41:28 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:41:53 - IsConnectionValid True
13:41:53 - IsConnectionValid True
13:41:53 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:22 - IsConnectionValid True
13:42:22 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:22 - IsConnectionValid True
13:42:22 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:25 - IsConnectionValid True
13:42:25 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:25 - IsConnectionValid True
13:42:25 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:27 - IsConnectionValid True
13:42:27 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 1  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:28 - IsConnectionValid True
13:42:28 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 10  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:29 - IsConnectionValid True
13:42:29 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 23  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:33 - IsConnectionValid True
13:42:33 - IsConnectionValid True
13:42:33 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =1 OR 1=0) AND (DepartmentID =9 OR 9=0) AND (SectionID =105 OR 105=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:33 - IsConnectionValid True
13:42:33 - IsConnectionValid True
13:42:33 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =1 OR 1=0) AND (DepartmentID =9 OR 9=0) AND (SectionID =105 OR 105=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:34 - IsConnectionValid True
13:42:34 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:34 - IsConnectionValid True
13:42:34 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE   t.TenantID =1 AND t.Father = 0  GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel  ORDER BY t.Code ASCQuery
13:42:39 - IsConnectionValid True
13:42:39 - IsConnectionValid True
13:42:39 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:39 - IsConnectionValid True
13:42:39 - IsConnectionValid True
13:42:39 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:40 - IsConnectionValid True
13:42:40 - IsConnectionValid True
13:42:40 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:41 - IsConnectionValid True
13:42:41 - IsConnectionValid True
13:42:41 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:41 - IsConnectionValid True
13:42:41 - IsConnectionValid True
13:42:41 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:41 - IsConnectionValid True
13:42:41 - IsConnectionValid True
13:42:41 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:42 - IsConnectionValid True
13:42:42 - IsConnectionValid True
13:42:42 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:42 - IsConnectionValid True
13:42:42 - IsConnectionValid True
13:42:42 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:49 - IsConnectionValid True
13:42:49 - IsConnectionValid True
13:42:49 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:50 - IsConnectionValid True
13:42:50 - IsConnectionValid True
13:42:50 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:42:50 - IsConnectionValid True
13:42:50 - IsConnectionValid True
13:42:50 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:43:53 - IsConnectionValid True
13:47:20 - IsConnectionValid True
13:47:22 - IsConnectionValid True
13:47:27 - IsConnectionValid True
13:47:27 - IsConnectionValid True
13:47:30 - IsConnectionValid True
13:47:34 - IsConnectionValid True
13:47:34 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 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 ID ASC  Query
13:47:34 - IsConnectionValid True
13:47: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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:38 - IsConnectionValid True
13:47:39 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:58 - IsConnectionValid True
13:48:00 - IsConnectionValid True
13:48:03 - IsConnectionValid True
13:48:03 - IsConnectionValid True
13:48:03 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:04 - IsConnectionValid True
13:48:04 - IsConnectionValid True
13:48:04 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:04 - IsConnectionValid True
13:48:04 - IsConnectionValid True
13:48:04 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:12 - IsConnectionValid True
13:48:12 - IsConnectionValid True
13:48:12 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:12 - IsConnectionValid True
13:48:12 - IsConnectionValid True
13:48:12 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:13 - IsConnectionValid True
13:48:13 - IsConnectionValid True
13:48:13 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:14 - IsConnectionValid True
13:48:14 - IsConnectionValid True
13:48:14 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:14 - IsConnectionValid True
13:48:14 - IsConnectionValid True
13:48:14 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:14 - IsConnectionValid True
13:48:14 - IsConnectionValid True
13:48:14 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:14 - IsConnectionValid True
13:48:14 - IsConnectionValid True
13:48:14 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:20 - IsConnectionValid True
13:48:20 - IsConnectionValid True
13:48:20 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:20 - IsConnectionValid True
13:48:20 - IsConnectionValid True
13:48:20 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:20 - IsConnectionValid True
13:48:20 - IsConnectionValid True
13:48:20 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:20 - IsConnectionValid True
13:48:20 - IsConnectionValid True
13:48:20 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:27 - IsConnectionValid True
13:48:27 - IsConnectionValid True
13:48:27 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
13:48:27 - IsConnectionValid True
13:48:27 - IsConnectionValid True
13:48:27 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
14:07:54 - IsConnectionValid True
14:07:54 - IsConnectionValid True
14:07:54 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
14:08:04 - IsConnectionValid True
14:08:04 - IsConnectionValid True
14:08:04 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
14:08:04 - IsConnectionValid True
14:08:04 - IsConnectionValid True
14:08:04 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
14:08:04 - IsConnectionValid True
14:08:04 - IsConnectionValid True
14:08:04 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(OrigTransactionDate AS Date) >= @val1 AND CAST(OrigTransactionDate AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND TransType = @val4 AND IsReturnEffect = @val5 AND UserID = @val6 AND EmployeeCode >= @val7 AND EmployeeCode <= @val8 AND TransactionUserID = @val9 AND IsNotManualEntry = @val10 AND IsReserve = @val11 AND Loans = @val12 AND IsInsurance = @val13 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) 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 (Amount =0 OR 0=0) ORDER BY Code  Query
15:10:49 - IsConnectionValid True
15:19:36 - IsConnectionValid True
15:19:41 - IsConnectionValid True
15:19:41 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
15:19:41 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
15:19:41 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
15:19:41 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
15:19:41 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 25
15:19:41 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 0
15:19:41 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
15:19:41 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 0
15:19:45 - IsConnectionValid True
15:26:02 - IsConnectionValid True