09:48:57 - IsConnectionValid True 09:48:57 - IsConnectionValid True 09:49:04 - IsConnectionValid True 09:49:04 - IsConnectionValid True 09:49:09 - IsConnectionValid True 09:49:11 - IsConnectionValid True 09:49:15 - IsConnectionValid True 09:49:15 - IsConnectionValid True 09:49:15 - IsConnectionValid True 09:49:15 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 09:49:15 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 09:49:15 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 09:49:18 - IsConnectionValid True 09:49:23 - IsConnectionValid True 09:49:26 - IsConnectionValid True 09:49:26 - 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 09:49:26 - IsConnectionValid True 09:49:26 - 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 09:49:28 - IsConnectionValid True 09:49:29 - IsConnectionValid True 09:49:32 - IsConnectionValid True 09:49:32 - 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 09:49:32 - IsConnectionValid True 09:49:32 - 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 09:49:35 - IsConnectionValid True 09:49:38 - IsConnectionValid True 09:49:38 - 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 09:49:38 - IsConnectionValid True 09:49:38 - 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 09:49:41 - IsConnectionValid True 09:49:44 - IsConnectionValid True 09:49:44 - 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 09:49:44 - IsConnectionValid True 09:49:44 - 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 09:53:53 - IsConnectionValid True 09:53:56 - IsConnectionValid True 09:53:56 - 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 09:53:56 - IsConnectionValid True 09:53:56 - 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 09:54:00 - IsConnectionValid True 09:56:36 - IsConnectionValid True 09:56:37 - IsConnectionValid True 10:16:04 - IsConnectionValid True 10:16:07 - IsConnectionValid True 10:16:07 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:16:09 - IsConnectionValid True 10:16:26 - IsConnectionValid True 10:18:46 - IsConnectionValid True 10:18:48 - IsConnectionValid True 10:18:48 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:21:15 - IsConnectionValid True 10:21:17 - IsConnectionValid True 10:21:17 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:21:50 - IsConnectionValid True 10:21:52 - IsConnectionValid True 10:21:52 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:21:54 - IsConnectionValid True 10:23:48 - IsConnectionValid True 10:24:44 - IsConnectionValid True 10:25:29 - IsConnectionValid True 10:25:35 - IsConnectionValid True 10:25:35 - IsConnectionValid True 10:25:41 - IsConnectionValid True 10:25:42 - IsConnectionValid True 10:25:44 - IsConnectionValid True 10:25:44 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:25:46 - IsConnectionValid True 10:27:31 - IsConnectionValid True 10:27:33 - IsConnectionValid True 10:27:33 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:27:38 - IsConnectionValid True 10:30:35 - IsConnectionValid True 10:30:36 - IsConnectionValid True 10:41:09 - IsConnectionValid True 10:41:10 - IsConnectionValid True 10:41:27 - IsConnectionValid True 10:41:27 - IsConnectionValid True 10:43:49 - IsConnectionValid True 10:43:49 - IsConnectionValid True 10:43:52 - IsConnectionValid True 10:43:52 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:45:14 - IsConnectionValid True 10:45:16 - IsConnectionValid True 10:45:16 - IsConnectionValid True 10:48:48 - IsConnectionValid True 10:48:48 - IsConnectionValid True 10:59:24 - IsConnectionValid True 10:59:25 - IsConnectionValid True 10:59:29 - IsConnectionValid True 10:59:29 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 10:59:31 - IsConnectionValid True 10:59:48 - IsConnectionValid True 10:59:57 - IsConnectionValid True 10:59:57 - SELECT DISTINCT ISNULL(ShowTransactionEntryTemp,0) AS ShowTransactionEntryTemp FROM Users WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 Query 10:59:57 - IsConnectionValid True 10:59:58 - IsConnectionValid True 10:59:58 - SELECT DISTINCT ISNULL(ShowTransactionEntryTemp,0) AS ShowTransactionEntryTemp FROM Users WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 Query 10:59:58 - IsConnectionValid True 11:06:54 - IsConnectionValid True 11:06:57 - IsConnectionValid True 11:06:58 - IsConnectionValid True 11:06:58 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:07:02 - IsConnectionValid True 11:07:10 - IsConnectionValid True 11:07:10 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 13:08:36 - IsConnectionValid True 13:08:39 - IsConnectionValid True 13:08:39 - IsConnectionValid True 13:08:45 - IsConnectionValid True 13:08:45 - IsConnectionValid True 13:08:46 - IsConnectionValid True 13:09:01 - IsConnectionValid True 13:09:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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:09:05 - IsConnectionValid True 13:09:05 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:09:12 - IsConnectionValid True 13:09:12 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:13:57 - IsConnectionValid True 13:14:13 - IsConnectionValid True 13:14:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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:15 - IsConnectionValid True 13:14:15 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:14:16 - IsConnectionValid True 13:14:16 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:18:35 - IsConnectionValid True 13:19:01 - IsConnectionValid True 13:19:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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:19:03 - IsConnectionValid True 13:19:03 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:19:04 - IsConnectionValid True 13:19:04 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:19:10 - IsConnectionValid True 13:19:10 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:28:44 - IsConnectionValid True 13:28:59 - IsConnectionValid True 13:28:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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:29:01 - IsConnectionValid True 13:29:01 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:29:02 - IsConnectionValid True 13:29:02 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:41:16 - IsConnectionValid True 13:41:37 - IsConnectionValid True 13:41:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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 14:02:28 - IsConnectionValid True 14:02:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo 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 14:02:29 - IsConnectionValid True 14:02:29 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:02:33 - IsConnectionValid True 14:02:33 - SELECT * 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(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:02:41 - IsConnectionValid True 14:02:45 - IsConnectionValid True 14:03:07 - IsConnectionValid True