09:31:29 - MainConnections 09:31:29 - AccConnections 09:31:29 - IsConnectionValid False 09:31:30 - MainConnections 09:31:30 - AccConnections 09:31:30 - IsConnectionValid False 09:31:30 - MainConnections 09:31:30 - AccConnections 09:31:30 - IsConnectionValid False 09:33:28 - IsConnectionValid False 09:33:28 - IsConnectionValid False 09:33:28 - IsConnectionValid False 09:36:15 - 3 09:36:15 - MainConnection 09:36:15 - AccConnection 09:36:15 - IsConnectionValid False 09:36:15 - 3 09:36:15 - MainConnection 09:36:15 - AccConnection 09:36:15 - IsConnectionValid False 09:36:15 - 3 09:36:15 - MainConnection 09:36:15 - AccConnection 09:36:15 - IsConnectionValid False 09:37:10 - 3 09:37:10 - MainConnection 09:37:10 - AccConnection 09:37:10 - IsConnectionValid True 09:37:10 - 3 09:37:10 - MainConnection 09:37:10 - AccConnection 09:37:10 - IsConnectionValid True 09:37:45 - 3 09:37:45 - MainConnection 09:37:45 - AccConnection 09:37:55 - IsConnectionValid False 09:38:15 - 3 09:38:15 - MainConnection 09:38:15 - AccConnection 09:38:25 - IsConnectionValid False 09:38:25 - 3 09:38:25 - MainConnection 09:38:25 - AccConnection 09:38:25 - IsConnectionValid False 09:38:26 - 3 09:38:26 - MainConnection 09:38:26 - AccConnection 09:38:26 - IsConnectionValid False 09:42:44 - IsConnectionValid False 09:42:44 - IsConnectionValid False 09:42:44 - IsConnectionValid False 09:43:29 - IsConnectionValid True 09:43:29 - IsConnectionValid True 09:43:34 - IsConnectionValid True 10:57:13 - IsConnectionValid True 10:57:13 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 10:57:13 - IsConnectionValid True 10:57:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 10:57:19 - IsConnectionValid True 10:57:19 - 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, 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 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 10:58:29 - IsConnectionValid True 10:58:29 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 10:58:29 - IsConnectionValid True 10:58:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 10:58:32 - IsConnectionValid True 10:58:32 - 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 10:58:50 - IsConnectionValid True 10:58:50 - 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 10:58:53 - IsConnectionValid True 10:58:53 - 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 10:59:02 - IsConnectionValid True 10:59: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 10:59:06 - IsConnectionValid True 10:59:18 - IsConnectionValid True 10:59:18 - 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 10:59:21 - IsConnectionValid True 10:59:24 - IsConnectionValid True 10:59:24 - 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 11:00:12 - IsConnectionValid True 11:00:12 - 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 11:00:16 - IsConnectionValid True 11:00:18 - IsConnectionValid True 11:29:59 - IsConnectionValid True 11:29:59 - IsConnectionValid True 11:29:59 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:29:59 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:29:59 - IsConnectionValid True 11:29: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, 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 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 11:29:59 - IsConnectionValid True 11:29: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, 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 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 11:30:10 - IsConnectionValid True 11:30:10 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:30:10 - IsConnectionValid True 11:30:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:30:13 - IsConnectionValid True 11:30:13 - 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 11:30:17 - IsConnectionValid True 11:30:20 - IsConnectionValid True 11:30:36 - IsConnectionValid True 11:30:39 - IsConnectionValid True 11:30:39 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:30:39 - IsConnectionValid True 11:30:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, 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 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 11:30:41 - IsConnectionValid True 11:30:41 - 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 11:30:43 - IsConnectionValid True 11:30:43 - 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 11:30:46 - IsConnectionValid True 11:30:47 - IsConnectionValid True 11:30:52 - IsConnectionValid True 11:32:10 - IsConnectionValid True 11:32:22 - IsConnectionValid True 11:32:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:32:29 - IsConnectionValid True 11:32:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:32:30 - IsConnectionValid True 11:32:30 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:32:30 - IsConnectionValid True 11:32:30 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 11:32:45 - IsConnectionValid True 11:32:45 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:45 - IsConnectionValid True 11:32:47 - IsConnectionValid True 11:32:47 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:47 - IsConnectionValid True 11:32:49 - IsConnectionValid True 11:32:49 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:49 - IsConnectionValid True 11:32:50 - IsConnectionValid True 11:32:50 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:50 - IsConnectionValid True 11:32:51 - IsConnectionValid True 11:32:51 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:51 - IsConnectionValid True 11:32:53 - IsConnectionValid True 11:32:53 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:53 - IsConnectionValid True 11:32:55 - IsConnectionValid True 11:32:55 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:55 - IsConnectionValid True 11:32:56 - IsConnectionValid True 11:32:56 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:56 - IsConnectionValid True 11:32:57 - IsConnectionValid True 11:32:57 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:57 - IsConnectionValid True 11:32:58 - IsConnectionValid True 11:32:58 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:32:58 - IsConnectionValid True 11:33:00 - IsConnectionValid True 11:33:00 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:00 - IsConnectionValid True 11:33:00 - IsConnectionValid True 11:33:00 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:00 - IsConnectionValid True 11:33:01 - IsConnectionValid True 11:33:01 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:01 - IsConnectionValid True 11:33:02 - IsConnectionValid True 11:33:02 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:02 - IsConnectionValid True 11:33:04 - IsConnectionValid True 11:33:04 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:04 - IsConnectionValid True 11:33:10 - IsConnectionValid True 11:33:10 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:33:10 - IsConnectionValid True 11:33:20 - IsConnectionValid True 11:33:20 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:33:20 - IsConnectionValid True 11:33:20 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:33:20 - IsConnectionValid True 11:33:20 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:33:20 - IsConnectionValid True 11:33:20 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =1 or 1=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 11:41:42 - IsConnectionValid True 11:42:22 - IsConnectionValid True 11:47:51 - IsConnectionValid True 11:50:39 - IsConnectionValid True 11:50:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:50:47 - IsConnectionValid True 11:50:47 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:50:47 - IsConnectionValid True 11:50:47 - SELECT DISTINCT TransactionID AS TransID, Name AS TransName, Code AS TransCode, EmployeeCode AS Code, EmployeeName AS Name, EmployeeID AS ID, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, Amount AS Factor, AmountValue AS AmountValue, BasicSalary AS BasicSalary, Month_Divide AS Month_Divide, WorkingHours AS WorkingHours, InsertType AS InsertType, Reccuring AS Reccuring, Loans AS Loans, TransEntryName AS TransEntryName, TransactionDate AS TransactionDate, Description AS Description, SectionName AS SectionName, DateLeft AS DateLeft, DateBegin AS DateBegin, LinkWithAccNo AS LinkWithAccNo, EmpCreditAcc AS EmpCreditAcc, EmpsulfAcc AS EmpsulfAcc, Factor AS Multiply, ISNull(null,0) AS OK, ISNull(null,0) AS PrevAmount FROM VwEmpTransactionsWithSecurity WHERE TenantID = 1 AND TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and TransactionID = @val3 Query 11:50:47 - (1-gen-1002) : Invalid column name 'EmpCreditAcc'. Invalid column name 'EmpsulfAcc'. 11:50:47 - IsConnectionValid True 11:51:16 - IsConnectionValid True 11:51:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:16 - IsConnectionValid True 11:51:16 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:51:17 - IsConnectionValid True 11:51:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 11:51:21 - IsConnectionValid True 11:51:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and IsSalaryDetails = @val1 and IsReserve = @val2 and IsInsurance = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:28 - IsConnectionValid True 11:51:28 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:51:28 - IsConnectionValid True 11:51:28 - SELECT DISTINCT TransactionID AS TransID, Name AS TransName, Code AS TransCode, EmployeeCode AS Code, EmployeeName AS Name, EmployeeID AS ID, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, Amount AS Factor, AmountValue AS AmountValue, BasicSalary AS BasicSalary, Month_Divide AS Month_Divide, WorkingHours AS WorkingHours, InsertType AS InsertType, Reccuring AS Reccuring, Loans AS Loans, TransEntryName AS TransEntryName, TransactionDate AS TransactionDate, Description AS Description, SectionName AS SectionName, DateLeft AS DateLeft, DateBegin AS DateBegin, LinkWithAccNo AS LinkWithAccNo, EmpCreditAcc AS EmpCreditAcc, EmpsulfAcc AS EmpsulfAcc, Factor AS Multiply, ISNull(null,0) AS OK, ISNull(null,0) AS PrevAmount FROM VwEmpTransactionsWithSecurity WHERE TenantID = 1 AND TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and TransactionID = @val3 Query 11:51:28 - (1-gen-1002) : Invalid column name 'EmpCreditAcc'. Invalid column name 'EmpsulfAcc'. 11:51:28 - IsConnectionValid True 11:51:47 - IsConnectionValid True 11:51:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:51:49 - IsConnectionValid True 11:51:49 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:51:49 - IsConnectionValid True 11:51:49 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 11:52:15 - IsConnectionValid True 11:52:15 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:52:15 - IsConnectionValid True 11:52:22 - IsConnectionValid True 11:52:22 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 11:52:22 - IsConnectionValid True 13:13:08 - IsConnectionValid True 13:13:17 - IsConnectionValid True 13:13:17 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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:13:17 - IsConnectionValid True 13:13:17 - 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, 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 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:13:20 - IsConnectionValid True 13:13:20 - 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:13:24 - IsConnectionValid True 13:13:25 - IsConnectionValid True 13:13:50 - IsConnectionValid True 13:13:55 - IsConnectionValid True 13:13:55 - SELECT ID AS ID, Code AS Code, Name AS Name, 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 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:13:56 - IsConnectionValid True 13:13:56 - 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, 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 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:14:22 - IsConnectionValid True 13:14:22 - 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:14:25 - IsConnectionValid True 13:14:27 - IsConnectionValid True 13:14:30 - IsConnectionValid True 13:14:52 - IsConnectionValid True 14:29:19 - IsConnectionValid True 14:29:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:29:21 - IsConnectionValid True 14:29:21 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:29:21 - IsConnectionValid True 14:29:21 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 14:29:22 - IsConnectionValid True 14:29:22 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:29:22 - IsConnectionValid True 14:29:22 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:29:22 - IsConnectionValid True 14:29:22 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:29:22 - IsConnectionValid True 14:29:22 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 15:46:17 - IsConnectionValid True 15:46:26 - IsConnectionValid True 15:46:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:46:27 - IsConnectionValid True 15:46:27 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:46:27 - IsConnectionValid True 15:46:27 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 15:46:35 - IsConnectionValid True 15:46:35 - (2-payroll-0010002) : Invalid column name 'TenantID'. 15:46:35 - IsConnectionValid True 15:46:35 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:46:35 - IsConnectionValid True 15:46:35 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:46:35 - IsConnectionValid True 15:46:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 15:47:57 - IsConnectionValid True 15:48:04 - IsConnectionValid True 15:48:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:48:08 - IsConnectionValid True 15:48:08 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:48:08 - IsConnectionValid True 15:48:08 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 15:48:16 - IsConnectionValid True 15:48:16 - (2-payroll-0010002) : Invalid column name 'TenantID'. 15:48:16 - IsConnectionValid True 15:48:16 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:48:16 - IsConnectionValid True 15:48:16 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 15:48:16 - IsConnectionValid True 15:48:16 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 15:48:25 - IsConnectionValid True 15:48:25 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 15:48:25 - IsConnectionValid True 15:48:35 - IsConnectionValid True 15:48:35 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 15:48:35 - IsConnectionValid True 15:49:17 - IsConnectionValid True