10:14:43 - IsConnectionValid True 10:14:46 - IsConnectionValid True 10:14:46 - IsConnectionValid True 10:14:51 - IsConnectionValid True 10:14:51 - IsConnectionValid True 10:14:54 - IsConnectionValid True 10:16:02 - IsConnectionValid True 10:16:19 - IsConnectionValid True 10:16:19 - 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 10:16:23 - IsConnectionValid True 10:16:23 - 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 10:16:34 - IsConnectionValid True 10:17:43 - IsConnectionValid True 10:27:53 - IsConnectionValid True 10:27:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM GroupToEnterTransactionTogother WHERE ID not in(SELECT TransGroupToCal From VwTransactionsWithSecurity WHERE [ID] NOT IN(SELECT [ID]from VwTransactionsWithSecurity WHERE USERID='Stc' and TenantID = 1)) and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:27:54 - IsConnectionValid True 10:27:54 - 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, VoucherType AS VoucherType, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 and TransGroupToCal = @val2 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) Query 10:27:54 - IsConnectionValid True 10:27:54 - 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 10:39:05 - IsConnectionValid True 10:39:18 - IsConnectionValid True 10:39:27 - IsConnectionValid True 10:55:25 - IsConnectionValid True 10:55:25 - 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 10:55:29 - IsConnectionValid True 10:55: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 10:56:05 - IsConnectionValid True 10:56:19 - IsConnectionValid True 10:56:22 - IsConnectionValid True 10:56:55 - IsConnectionValid True 10:58:09 - IsConnectionValid True 10:58:17 - IsConnectionValid True 10:58:17 - 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 10:58:21 - IsConnectionValid True 10:58:21 - 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 10:58:23 - IsConnectionValid True 10:58:23 - 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 10:58:32 - IsConnectionValid True 10:58:36 - IsConnectionValid True 10:58:37 - IsConnectionValid True 10:58:39 - IsConnectionValid True 10:58:51 - IsConnectionValid True 10:59:43 - IsConnectionValid True 11:00:01 - IsConnectionValid True 11:00:05 - IsConnectionValid True 11:00:06 - 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 11:00:10 - IsConnectionValid True 11:00: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 11:00:19 - IsConnectionValid True 11:00:22 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:31 - IsConnectionValid True 11:00:35 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:08:36 - IsConnectionValid True 11:08:36 - 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 11:10:07 - IsConnectionValid True 11:24:14 - IsConnectionValid True 11:24:20 - IsConnectionValid True 11:24:20 - 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 11:24:34 - IsConnectionValid True 11:24:34 - 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 11:24:37 - IsConnectionValid True 11:24:37 - 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 11:24:42 - IsConnectionValid True 11:24:45 - IsConnectionValid True 11:24:48 - IsConnectionValid True 11:24:52 - IsConnectionValid True 11:24:55 - IsConnectionValid True 11:24:59 - IsConnectionValid True 11:25:40 - IsConnectionValid True 11:25:45 - IsConnectionValid True 11:25:45 - 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 11:25:50 - IsConnectionValid True 11:25:50 - 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 11:25:54 - IsConnectionValid True 11:25:54 - 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 11:25:57 - IsConnectionValid True 11:25:59 - IsConnectionValid True 11:25:59 - (3-hr-0010001) : Error converting data type varchar to numeric. 11:26:00 - IsConnectionValid True 11:26:06 - IsConnectionValid True 11:26:14 - IsConnectionValid True 11:27:37 - IsConnectionValid True 11:27:44 - IsConnectionValid True 11:27:44 - 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 11:27:47 - IsConnectionValid True 11:27:47 - 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 11:27:53 - IsConnectionValid True 11:28:46 - IsConnectionValid True 11:28:52 - IsConnectionValid True 11:29:10 - IsConnectionValid True 11:29:15 - IsConnectionValid True 11:29:18 - IsConnectionValid True 11:29:31 - IsConnectionValid True 11:29:35 - IsConnectionValid True 11:29:35 - 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 11:29:38 - IsConnectionValid True 11:29:38 - 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 11:29:47 - IsConnectionValid True 11:29:56 - IsConnectionValid True 11:29:59 - IsConnectionValid True 11:30:03 - IsConnectionValid True 11:30:06 - IsConnectionValid True 11:34:28 - IsConnectionValid True 11:34:32 - IsConnectionValid True 11:34:32 - 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 11:34:35 - IsConnectionValid True 11:34:35 - 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 11:34:40 - IsConnectionValid True 11:34:40 - 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 11:34:52 - IsConnectionValid True 11:35:12 - IsConnectionValid True 11:35:18 - IsConnectionValid True 11:35:23 - IsConnectionValid True 11:35:27 - IsConnectionValid True 11:37:51 - IsConnectionValid True 11:37:56 - IsConnectionValid True 11:37:56 - 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 11:37:59 - IsConnectionValid True 11:37:59 - 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 11:38:09 - IsConnectionValid True 11:38:14 - IsConnectionValid True 11:39:04 - IsConnectionValid True 11:39:11 - IsConnectionValid True 11:39:50 - IsConnectionValid True 11:40:06 - IsConnectionValid True 11:50:44 - IsConnectionValid True 11:50:53 - IsConnectionValid True 11:50:53 - 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 11:52:19 - IsConnectionValid True 11:52:24 - IsConnectionValid True 11:52:24 - 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 11:52:27 - IsConnectionValid True 11:52:27 - 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 11:52:32 - IsConnectionValid True 11:52:36 - IsConnectionValid True 11:53:41 - IsConnectionValid True 11:53:46 - IsConnectionValid True 11:53:46 - 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 11:53:48 - IsConnectionValid True 11:53:48 - 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 11:53:54 - IsConnectionValid True 11:53:59 - IsConnectionValid True 11:54:06 - IsConnectionValid True 11:54:07 - IsConnectionValid True 11:54:10 - IsConnectionValid True 11:54:11 - IsConnectionValid True 11:55:10 - IsConnectionValid True 11:55:14 - IsConnectionValid True 11:55:14 - 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 11:55:17 - IsConnectionValid True 11:55:17 - 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 11:55:23 - IsConnectionValid True 11:58:40 - IsConnectionValid True 11:58:45 - IsConnectionValid True 11:58:45 - 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 11:58:47 - IsConnectionValid True 11:58:47 - 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 12:00:46 - IsConnectionValid True 12:00:50 - IsConnectionValid True 12:00:50 - 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 12:00:52 - IsConnectionValid True 12:00:52 - 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 12:01:01 - IsConnectionValid True 12:01:08 - IsConnectionValid True 12:20:26 - IsConnectionValid True 12:20:35 - IsConnectionValid True 12:20:35 - 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 12:20:38 - IsConnectionValid True 12:20:38 - 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 12:20:43 - IsConnectionValid True 12:20:47 - IsConnectionValid True 12:20:52 - IsConnectionValid True 12:20:55 - IsConnectionValid True 12:23:44 - IsConnectionValid True 12:34:42 - IsConnectionValid True 12:34:46 - IsConnectionValid True 12:34:46 - 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 12:34:48 - IsConnectionValid True 12:34:48 - 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 12:34:57 - IsConnectionValid True 12:34:59 - IsConnectionValid True 12:35:02 - IsConnectionValid True 12:35:06 - IsConnectionValid True 12:35:13 - IsConnectionValid True 12:35:17 - IsConnectionValid True 12:35:21 - IsConnectionValid True 12:35:24 - IsConnectionValid True 12:35:27 - IsConnectionValid True 12:39:49 - IsConnectionValid True 12:39:55 - IsConnectionValid True 12:39:55 - 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 12:39:57 - IsConnectionValid True 12:39:57 - 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 12:42:01 - IsConnectionValid True 12:42:05 - IsConnectionValid True 12:42:05 - 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 12:42:08 - IsConnectionValid True 12:42:08 - 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 12:46:06 - IsConnectionValid True 12:46:10 - IsConnectionValid True 12:46:10 - 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 12:46:13 - IsConnectionValid True 12:46:13 - 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 12:46:22 - IsConnectionValid True 12:46:50 - IsConnectionValid True 12:46:55 - IsConnectionValid True 12:46:55 - 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 12:46:58 - IsConnectionValid True 12:46:58 - 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 12:47:04 - IsConnectionValid True 12:47:18 - IsConnectionValid True 12:47:24 - IsConnectionValid True 12:47:24 - 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 12:47:26 - IsConnectionValid True 12:47:26 - 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 12:47:33 - IsConnectionValid True 12:47:36 - IsConnectionValid True 12:47:48 - IsConnectionValid True 12:47:49 - IsConnectionValid True 12:47:50 - IsConnectionValid True 12:47:50 - IsConnectionValid True 12:47:52 - IsConnectionValid True 12:47:53 - IsConnectionValid True 12:47:54 - IsConnectionValid True 12:47:54 - IsConnectionValid True 12:47:54 - IsConnectionValid True 12:47:54 - IsConnectionValid True 12:47:55 - IsConnectionValid True 12:47:55 - IsConnectionValid True 12:47:55 - IsConnectionValid True 12:47:56 - IsConnectionValid True 12:47:56 - IsConnectionValid True 12:47:56 - IsConnectionValid True 12:47:56 - IsConnectionValid True 12:47:57 - IsConnectionValid True 12:47:57 - IsConnectionValid True 12:47:57 - IsConnectionValid True 12:47:58 - IsConnectionValid True 12:47:58 - IsConnectionValid True 12:47:58 - IsConnectionValid True 12:48:00 - IsConnectionValid True 12:48:04 - IsConnectionValid True 12:48:04 - IsConnectionValid True 12:48:04 - IsConnectionValid True 12:48:04 - IsConnectionValid True 12:48:06 - IsConnectionValid True 12:48:06 - IsConnectionValid True 12:48:06 - IsConnectionValid True 12:48:08 - IsConnectionValid True 12:48:18 - IsConnectionValid True 12:48:19 - IsConnectionValid True 12:48:19 - IsConnectionValid True 12:48:19 - IsConnectionValid True 12:48:20 - IsConnectionValid True 12:48:21 - IsConnectionValid True 12:48:21 - IsConnectionValid True 12:48:21 - IsConnectionValid True 12:48:21 - IsConnectionValid True 12:48:22 - IsConnectionValid True 12:48:22 - IsConnectionValid True 12:48:22 - IsConnectionValid True 12:48:22 - IsConnectionValid True 12:48:22 - IsConnectionValid True 12:48:23 - IsConnectionValid True 12:48:23 - IsConnectionValid True 12:48:24 - IsConnectionValid True 12:48:29 - IsConnectionValid True 12:49:52 - IsConnectionValid True 12:50:00 - IsConnectionValid True 12:50: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 12:50:03 - IsConnectionValid True 12:50: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 12:50:11 - IsConnectionValid True 12:50:15 - IsConnectionValid True 12:50:17 - IsConnectionValid True 12:51:01 - IsConnectionValid True 12:51:05 - IsConnectionValid True 12:51:05 - 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 12:51:08 - IsConnectionValid True 12:51:08 - 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 12:51:16 - IsConnectionValid True 12:51:16 - (3-hr-0010001) : Error converting data type varchar to numeric. 12:51:16 - IsConnectionValid True 12:51:21 - IsConnectionValid True 12:51:22 - IsConnectionValid True 12:51:23 - IsConnectionValid True 12:51:24 - IsConnectionValid True 12:51:25 - IsConnectionValid True 12:51:26 - IsConnectionValid True 12:51:26 - IsConnectionValid True 12:51:26 - IsConnectionValid True 12:51:27 - IsConnectionValid True 12:51:27 - IsConnectionValid True 12:51:31 - IsConnectionValid True 12:51:38 - IsConnectionValid True 12:51:38 - (3-hr-0010001) : Error converting data type varchar to numeric. 12:51:38 - IsConnectionValid True 12:51:47 - IsConnectionValid True 12:51:47 - IsConnectionValid True 12:51:47 - IsConnectionValid True 12:51:48 - IsConnectionValid True 12:51:48 - IsConnectionValid True 12:51:48 - IsConnectionValid True 12:51:48 - IsConnectionValid True 12:51:50 - IsConnectionValid True 12:52:35 - IsConnectionValid True 12:52:36 - IsConnectionValid True 12:52:37 - IsConnectionValid True 12:52:37 - IsConnectionValid True 12:52:37 - IsConnectionValid True 12:52:38 - IsConnectionValid True 12:52:38 - IsConnectionValid True 12:52:38 - IsConnectionValid True 12:52:38 - IsConnectionValid True 12:52:38 - IsConnectionValid True 12:52:39 - IsConnectionValid True 12:53:02 - IsConnectionValid True 12:53:03 - IsConnectionValid True 12:53:04 - IsConnectionValid True 12:53:05 - IsConnectionValid True 12:53:06 - IsConnectionValid True 12:53:06 - IsConnectionValid True 12:53:07 - IsConnectionValid True 12:53:07 - IsConnectionValid True 12:53:07 - IsConnectionValid True 12:53:10 - IsConnectionValid True 12:53:11 - IsConnectionValid True 12:53:11 - IsConnectionValid True 12:53:11 - IsConnectionValid True 12:53:11 - IsConnectionValid True 12:53:11 - IsConnectionValid True 12:53:12 - IsConnectionValid True 12:53:12 - IsConnectionValid True 12:53:12 - IsConnectionValid True 12:53:12 - IsConnectionValid True 12:53:12 - IsConnectionValid True 12:53:13 - IsConnectionValid True 12:53:13 - IsConnectionValid True 12:53:13 - IsConnectionValid True 12:53:13 - IsConnectionValid True 12:53:13 - IsConnectionValid True 12:53:14 - IsConnectionValid True 12:53:14 - IsConnectionValid True 12:53:15 - IsConnectionValid True 12:53:15 - IsConnectionValid True 12:53:15 - IsConnectionValid True 12:53:15 - IsConnectionValid True 12:53:15 - IsConnectionValid True 12:53:16 - IsConnectionValid True 12:53:16 - IsConnectionValid True 12:53:16 - IsConnectionValid True 12:53:17 - IsConnectionValid True 12:53:29 - IsConnectionValid True 12:53:31 - IsConnectionValid True 12:56:54 - IsConnectionValid True 12:56:57 - IsConnectionValid True 12:56:57 - 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 12:56:59 - IsConnectionValid True 12:56:59 - 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 12:57:07 - IsConnectionValid True 12:57:10 - IsConnectionValid True 12:57:14 - IsConnectionValid True 12:57:15 - IsConnectionValid True 12:57:17 - IsConnectionValid True 12:57:18 - IsConnectionValid True 12:57:18 - IsConnectionValid True 12:57:19 - IsConnectionValid True 12:57:19 - IsConnectionValid True 12:57:19 - IsConnectionValid True 12:57:19 - IsConnectionValid True 12:57:20 - IsConnectionValid True 12:57:20 - IsConnectionValid True 12:57:20 - IsConnectionValid True 12:57:20 - IsConnectionValid True 12:57:21 - IsConnectionValid True 12:57:21 - IsConnectionValid True 12:57:21 - IsConnectionValid True 12:57:22 - IsConnectionValid True 12:57:22 - IsConnectionValid True 12:57:22 - IsConnectionValid True 12:57:24 - IsConnectionValid True 13:02:31 - IsConnectionValid True 13:02:35 - IsConnectionValid True 13:02:35 - 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:02:37 - IsConnectionValid True 13:02:37 - 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:02:59 - IsConnectionValid True 13:03:06 - IsConnectionValid True 13:03:06 - 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:03:08 - IsConnectionValid True 13:03:08 - 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:03:15 - IsConnectionValid True 13:03:20 - IsConnectionValid True 13:03:24 - IsConnectionValid True 13:03:27 - IsConnectionValid True 13:03:30 - IsConnectionValid True 13:03:30 - IsConnectionValid True 13:03:34 - IsConnectionValid True 13:03:38 - IsConnectionValid True 13:03:41 - IsConnectionValid True 13:10:58 - IsConnectionValid True 13:11:03 - IsConnectionValid True 13:11:03 - 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:11:05 - IsConnectionValid True 13:11: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:11:17 - IsConnectionValid True 13:11:22 - IsConnectionValid True 13:11:26 - IsConnectionValid True 13:11:27 - IsConnectionValid True 13:11:27 - IsConnectionValid True 13:11:28 - IsConnectionValid True 13:11:29 - IsConnectionValid True 13:11:30 - IsConnectionValid True 13:11:32 - IsConnectionValid True 13:11:33 - IsConnectionValid True 13:11:34 - IsConnectionValid True 13:11:35 - IsConnectionValid True 13:11:36 - IsConnectionValid True 13:11:36 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:11:37 - IsConnectionValid True 13:11:40 - IsConnectionValid True 13:11:41 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:11:41 - IsConnectionValid True 13:11:44 - IsConnectionValid True 13:11:45 - IsConnectionValid True 13:11:46 - IsConnectionValid True 13:11:47 - IsConnectionValid True 13:11:47 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:11:47 - IsConnectionValid True 13:12:39 - IsConnectionValid True 13:12:47 - IsConnectionValid True 13:12:47 - 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:12:49 - IsConnectionValid True 13:12:49 - 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:12:55 - IsConnectionValid True 13:12:56 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:12:56 - IsConnectionValid True 13:13:06 - IsConnectionValid True 13:13:07 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:13:07 - IsConnectionValid True 13:13:39 - IsConnectionValid True 13:13:45 - IsConnectionValid True 13:13:45 - 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:13:48 - IsConnectionValid True 13:13:48 - 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:55 - IsConnectionValid True 13:13:56 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:13:56 - IsConnectionValid True 13:14:01 - IsConnectionValid True 13:14:03 - IsConnectionValid True 13:14:04 - IsConnectionValid True 13:14:05 - IsConnectionValid True 13:14:06 - IsConnectionValid True 13:14:07 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:14:07 - IsConnectionValid True 13:15:33 - IsConnectionValid True 13:15:38 - IsConnectionValid True 13:15:38 - 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:15:40 - IsConnectionValid True 13:15:40 - 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:15:47 - IsConnectionValid True 13:15:48 - (3-hr-0010001) : Error converting data type varchar to numeric. 13:15:48 - IsConnectionValid True 13:16:31 - IsConnectionValid True 13:16:40 - IsConnectionValid True 13:16:40 - 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:16:42 - IsConnectionValid True 13:16:42 - 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:16:50 - IsConnectionValid True 13:16:55 - IsConnectionValid True 13:16:58 - IsConnectionValid True 13:16:59 - IsConnectionValid True 13:17:00 - IsConnectionValid True 13:17:01 - IsConnectionValid True 13:17:01 - IsConnectionValid True 13:17:01 - IsConnectionValid True 13:17:02 - IsConnectionValid True 13:17:05 - IsConnectionValid True 13:17:06 - IsConnectionValid True 13:17:07 - IsConnectionValid True 13:17:07 - IsConnectionValid True 13:17:08 - IsConnectionValid True 13:17:08 - IsConnectionValid True 13:17:09 - IsConnectionValid True 13:17:10 - IsConnectionValid True 13:17:13 - IsConnectionValid True 13:17:14 - IsConnectionValid True 13:17:16 - IsConnectionValid True 13:17:17 - IsConnectionValid True 13:17:17 - IsConnectionValid True 13:17:18 - IsConnectionValid True 13:17:27 - IsConnectionValid True 13:17:37 - IsConnectionValid True 13:17:39 - IsConnectionValid True 13:17:41 - IsConnectionValid True 13:17:42 - IsConnectionValid True 13:17:45 - IsConnectionValid True 13:18:03 - IsConnectionValid True 13:18:04 - IsConnectionValid True 13:18:05 - IsConnectionValid True 13:18:11 - IsConnectionValid True 13:18:54 - IsConnectionValid True 13:18:59 - IsConnectionValid True 13:18: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:19:01 - IsConnectionValid True 13:19: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:19:10 - IsConnectionValid True 13:19:20 - IsConnectionValid True 13:19:23 - IsConnectionValid True 13:19:25 - IsConnectionValid True 13:19:52 - IsConnectionValid True 13:21:21 - IsConnectionValid True 13:23:27 - IsConnectionValid True 13:23:31 - IsConnectionValid True 13:23:31 - 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:23:32 - IsConnectionValid True 13:23: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 13:23:41 - IsConnectionValid True 13:23:45 - IsConnectionValid True 13:23:49 - IsConnectionValid True 13:23:55 - IsConnectionValid True 13:24:01 - IsConnectionValid True 13:24:11 - IsConnectionValid True 13:24:48 - IsConnectionValid True 13:24:53 - IsConnectionValid True 13:24:54 - 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:24:56 - IsConnectionValid True 13:24:56 - 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:25:02 - IsConnectionValid True 13:25:09 - IsConnectionValid True 13:25:37 - IsConnectionValid True 13:25:43 - IsConnectionValid True 13:25:43 - 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:25:46 - IsConnectionValid True 13:25:46 - 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:25:57 - IsConnectionValid True 13:26:01 - IsConnectionValid True 13:26:20 - IsConnectionValid True 13:26:25 - IsConnectionValid True 13:26:32 - IsConnectionValid True 13:26:35 - IsConnectionValid True 13:26:39 - IsConnectionValid True 13:26:43 - IsConnectionValid True 13:28:42 - IsConnectionValid True 13:28:58 - IsConnectionValid True 13:29:22 - IsConnectionValid True 13:29:53 - IsConnectionValid True 13:29:57 - IsConnectionValid True 13:29:57 - 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:59 - IsConnectionValid True 13:29:59 - 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:30:22 - IsConnectionValid True 13:30:28 - IsConnectionValid True 13:30:37 - IsConnectionValid True 13:40:28 - IsConnectionValid True 13:40:32 - IsConnectionValid True 13:40:32 - 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:40:33 - IsConnectionValid True 13:40: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 13:41:05 - IsConnectionValid True 13:41:09 - IsConnectionValid True 13:41:09 - 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:41:12 - IsConnectionValid True 13:41: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:41:18 - IsConnectionValid True 13:41:21 - IsConnectionValid True 13:41:23 - IsConnectionValid True 13:41:26 - IsConnectionValid True 13:41:28 - IsConnectionValid True 13:41:32 - IsConnectionValid True 13:41:36 - IsConnectionValid True 13:42:20 - IsConnectionValid True 13:42:24 - IsConnectionValid True 13:42:24 - 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:42:26 - IsConnectionValid True 13:42:26 - 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:42:30 - IsConnectionValid True 13:42:34 - IsConnectionValid True 13:42:38 - IsConnectionValid True 13:42:55 - IsConnectionValid True 13:43:14 - IsConnectionValid True 13:43:35 - IsConnectionValid True 13:43:40 - IsConnectionValid True 13:43:40 - 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:43:42 - IsConnectionValid True 13:43:42 - 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:43:56 - IsConnectionValid True 13:44:00 - IsConnectionValid True 13:44:15 - IsConnectionValid True 13:44:17 - IsConnectionValid True 13:45:09 - IsConnectionValid True 13:45:14 - IsConnectionValid True 13:45:14 - 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:45:21 - IsConnectionValid True 13:45:21 - 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:45:48 - IsConnectionValid True 13:45:52 - IsConnectionValid True 13:45:52 - 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:45:55 - IsConnectionValid True 13:45:55 - 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:46:02 - IsConnectionValid True 13:47:16 - IsConnectionValid True 13:47:20 - IsConnectionValid True 13:47:20 - 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:47:24 - IsConnectionValid True 13:47:24 - 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:47:30 - IsConnectionValid True 13:47:32 - IsConnectionValid True 13:47:33 - IsConnectionValid True 13:47:35 - IsConnectionValid True 13:48:06 - IsConnectionValid True 13:48:10 - IsConnectionValid True 13:48:10 - 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:48:11 - IsConnectionValid True 13:48:11 - 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:48:16 - IsConnectionValid True 13:48:18 - IsConnectionValid True 13:50:08 - IsConnectionValid True 13:50:11 - IsConnectionValid True 13:50:11 - 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:50:13 - IsConnectionValid True 13:50:13 - 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:50:17 - IsConnectionValid True 13:50:18 - IsConnectionValid True 13:50:20 - IsConnectionValid True 13:50:22 - IsConnectionValid True 13:50:24 - IsConnectionValid True 13:50:43 - IsConnectionValid True 13:50:50 - IsConnectionValid True 13:50:50 - 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:50:52 - IsConnectionValid True 13:50:53 - 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:51:01 - IsConnectionValid True 13:51:08 - IsConnectionValid True 13:52:24 - IsConnectionValid True 13:52:30 - IsConnectionValid True 13:52:30 - 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:52:32 - IsConnectionValid True 13:52:32 - 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:52:39 - IsConnectionValid True 13:52:43 - IsConnectionValid True 13:52:46 - IsConnectionValid True 13:52:53 - IsConnectionValid True 13:52:56 - IsConnectionValid True 13:53:10 - IsConnectionValid True 13:55:20 - IsConnectionValid True 13:55:46 - IsConnectionValid True 13:55:46 - 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:55:49 - IsConnectionValid True 13:55:49 - 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:56:00 - IsConnectionValid True 14:04:42 - IsConnectionValid True 14:04:47 - IsConnectionValid True 14:04:47 - 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:04:49 - IsConnectionValid True 14:04:49 - 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:04:56 - IsConnectionValid True 14:05:56 - IsConnectionValid True 14:05:59 - IsConnectionValid True 14:06:01 - IsConnectionValid True 14:06:03 - IsConnectionValid True 14:06:50 - IsConnectionValid True 14:06:54 - IsConnectionValid True 14:07:04 - IsConnectionValid True 14:07:06 - IsConnectionValid True 14:09:18 - IsConnectionValid True 14:09:20 - IsConnectionValid True 14:09:25 - IsConnectionValid True 14:09:31 - IsConnectionValid True 14:19:25 - IsConnectionValid True 14:19:30 - IsConnectionValid True 14:19:31 - IsConnectionValid True 14:19:38 - IsConnectionValid True 14:19:38 - IsConnectionValid True 14:19:40 - IsConnectionValid True 14:19:44 - IsConnectionValid True 14:19:44 - 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:19:47 - IsConnectionValid True 14:19:47 - 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:20:19 - IsConnectionValid True 14:21:13 - IsConnectionValid True 14:21:20 - IsConnectionValid True 14:21:20 - 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:21:22 - IsConnectionValid True 14:21:22 - 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:21:32 - IsConnectionValid True 14:21:51 - IsConnectionValid True 14:22:44 - IsConnectionValid True 14:22:46 - IsConnectionValid True 14:22:47 - IsConnectionValid True 14:22:52 - IsConnectionValid True 14:22:55 - IsConnectionValid True 14:23:00 - IsConnectionValid True 14:23:06 - IsConnectionValid True 14:23:33 - IsConnectionValid True 14:23:34 - IsConnectionValid True 14:23:48 - IsConnectionValid True 14:24:07 - IsConnectionValid True 14:24:14 - IsConnectionValid True 14:24:23 - IsConnectionValid True 14:25:40 - IsConnectionValid True 14:25:45 - IsConnectionValid True 14:25:45 - 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:25:47 - IsConnectionValid True 14:25:47 - 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:25:51 - IsConnectionValid True 14:25:53 - IsConnectionValid True 14:25:56 - IsConnectionValid True 14:25:59 - IsConnectionValid True 14:26:10 - IsConnectionValid True 14:27:20 - IsConnectionValid True 14:27:24 - IsConnectionValid True 14:27:24 - 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:27:26 - IsConnectionValid True 14:27:26 - 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:27:32 - IsConnectionValid True 14:27:39 - IsConnectionValid True 14:27:41 - IsConnectionValid True 14:27:42 - IsConnectionValid True 14:27:43 - IsConnectionValid True 14:27:43 - IsConnectionValid True 14:27:44 - IsConnectionValid True 14:27:44 - IsConnectionValid True 14:27:44 - IsConnectionValid True 14:27:44 - IsConnectionValid True 14:27:45 - IsConnectionValid True 14:27:45 - IsConnectionValid True 14:27:45 - IsConnectionValid True 14:27:46 - IsConnectionValid True 14:27:46 - IsConnectionValid True 14:27:46 - IsConnectionValid True 14:27:46 - IsConnectionValid True 14:27:46 - IsConnectionValid True 14:27:47 - IsConnectionValid True 14:27:47 - IsConnectionValid True 14:27:48 - IsConnectionValid True 14:27:48 - IsConnectionValid True 14:27:52 - IsConnectionValid True 14:29:39 - IsConnectionValid True 14:29:44 - IsConnectionValid True 14:29:44 - 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:29:47 - IsConnectionValid True 14:29:47 - 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:29:52 - IsConnectionValid True 14:30:20 - IsConnectionValid True 14:30:39 - IsConnectionValid True 14:30:43 - IsConnectionValid True 14:30:43 - 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:30:45 - IsConnectionValid True 14:30:45 - 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:30:48 - IsConnectionValid True 14:31:19 - IsConnectionValid True 14:31:23 - IsConnectionValid True 14:31:23 - 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:31:25 - IsConnectionValid True 14:31:25 - 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:31:31 - IsConnectionValid True 14:31:33 - IsConnectionValid True 14:31:34 - IsConnectionValid True 14:31:35 - IsConnectionValid True 14:31:35 - IsConnectionValid True 14:31:35 - IsConnectionValid True 14:31:36 - IsConnectionValid True 14:31:37 - IsConnectionValid True 14:31:38 - IsConnectionValid True 14:39:53 - IsConnectionValid True 14:44:59 - IsConnectionValid True 14:45:05 - IsConnectionValid True 14:45:05 - 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:45:08 - IsConnectionValid True 14:45:08 - 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:45:37 - IsConnectionValid True 14:45:43 - IsConnectionValid True 14:45:43 - 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:45:45 - IsConnectionValid True 14:45:45 - 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:45:50 - IsConnectionValid True 14:45:53 - IsConnectionValid True 14:45:55 - IsConnectionValid True 14:45:57 - IsConnectionValid True 14:47:33 - IsConnectionValid True 14:47:37 - IsConnectionValid True 14:47: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:47:40 - IsConnectionValid True 14:47:40 - 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:47:46 - IsConnectionValid True 14:47:47 - IsConnectionValid True 14:47:48 - IsConnectionValid True 14:47:49 - IsConnectionValid True 14:47:50 - IsConnectionValid True 14:47:51 - IsConnectionValid True 14:47:57 - IsConnectionValid True 14:47:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM GroupToEnterTransactionTogother WHERE ID not in(SELECT TransGroupToCal From VwTransactionsWithSecurity WHERE [ID] NOT IN(SELECT [ID]from VwTransactionsWithSecurity WHERE USERID='Stc' and TenantID = 1)) and TenantID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:58 - IsConnectionValid True 14:47:58 - 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, VoucherType AS VoucherType, '' AS VoucherNo FROM VwTransactionsWithSecurity WHERE UserID = @val0 AND TenantID = @val1 and TransGroupToCal = @val2 AND ID NOT IN(SELECT TransactionTypeID FROM VacationTypes) Query 14:47:58 - IsConnectionValid True 14:47:58 - 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:48:03 - IsConnectionValid True 14:48:04 - IsConnectionValid True 14:48:06 - IsConnectionValid True 14:50:10 - IsConnectionValid True 14:50:18 - IsConnectionValid True 14:50:18 - 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 14:53:03 - IsConnectionValid True 14:53:03 - IsConnectionValid True 14:53:05 - IsConnectionValid True 14:53:10 - IsConnectionValid True 14:53:10 - 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:53:13 - IsConnectionValid True 14:53:13 - 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:53:25 - IsConnectionValid True 14:53:25 - 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:53:39 - IsConnectionValid True 14:53:39 - 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:53:47 - IsConnectionValid True 14:53:47 - 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:54:14 - IsConnectionValid True 14:54:21 - IsConnectionValid True 14:54:21 - 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:54:26 - IsConnectionValid True 14:54:26 - 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:54:52 - IsConnectionValid True 14:55:09 - IsConnectionValid True 14:55:09 - 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:55:11 - IsConnectionValid True 14:55:11 - 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:56:33 - IsConnectionValid True 15:00:15 - IsConnectionValid True 15:00:43 - IsConnectionValid True 15:00:51 - IsConnectionValid True 15:00:51 - 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 15:00:55 - IsConnectionValid True 15:00:55 - 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 15:01:45 - IsConnectionValid True 15:01:52 - IsConnectionValid True 15:01:52 - 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 15:01:54 - IsConnectionValid True 15:01:54 - 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 15:02:16 - IsConnectionValid True 15:02:16 - 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 15:02:18 - IsConnectionValid True 15:02:18 - 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 15:03:32 - IsConnectionValid True 15:03:41 - IsConnectionValid True 15:03:41 - 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 15:03:46 - IsConnectionValid True 15:03:46 - 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 15:04:28 - IsConnectionValid True 15:04:33 - IsConnectionValid True 15:04:33 - 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 15:04:36 - IsConnectionValid True 15:04:36 - 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 15:04:59 - IsConnectionValid True 15:04: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 15:05:02 - IsConnectionValid True 15:05: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 15:05:14 - IsConnectionValid True 15:05:14 - 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 15:05:17 - IsConnectionValid True 15:05:17 - 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 15:05:36 - IsConnectionValid True 15:06:44 - IsConnectionValid True 15:13:40 - IsConnectionValid True 15:15:15 - IsConnectionValid True 15:15:28 - IsConnectionValid True 15:15: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 15:15:31 - IsConnectionValid True 15:15:31 - 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 15:16:31 - IsConnectionValid True 15:16:32 - IsConnectionValid True 15:17:15 - IsConnectionValid True 15:17:20 - IsConnectionValid True 15:17:20 - 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 15:17:22 - IsConnectionValid True 15:17:22 - 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 15:19:42 - IsConnectionValid True 15:19:47 - IsConnectionValid True 15:19:47 - 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 15:19:49 - IsConnectionValid True 15:19:49 - 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 15:31:43 - IsConnectionValid True 15:31:48 - IsConnectionValid True 15:31:48 - 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 15:31:51 - IsConnectionValid True 15:31:51 - 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 15:31:57 - IsConnectionValid True 15:31:57 - 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 15:32:16 - IsConnectionValid True 15:32:23 - IsConnectionValid True 15:32:23 - 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 15:32:24 - IsConnectionValid True 15:32:24 - 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 15:33:46 - IsConnectionValid True 15:33:51 - IsConnectionValid True 15:33:51 - 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 15:33:53 - IsConnectionValid True 15:33:53 - 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 15:36:56 - IsConnectionValid True 15:37:01 - IsConnectionValid True 15:37: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 15:37:03 - IsConnectionValid True 15:37: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 15:37:06 - IsConnectionValid True 15:45:56 - IsConnectionValid True 15:46:02 - IsConnectionValid True 15:46:02 - 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 15:46:04 - IsConnectionValid True 15:46: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 15:46:11 - IsConnectionValid True 15:47:08 - IsConnectionValid True 15:47:17 - IsConnectionValid True 15:47:17 - 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 15:47:24 - IsConnectionValid True 15:47:24 - 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 15:47:28 - IsConnectionValid True 15:48:20 - IsConnectionValid True 15:48:27 - IsConnectionValid True 15:48:27 - 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 15:48:29 - IsConnectionValid True 15:48: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 15:48:34 - IsConnectionValid True 15:48:47 - IsConnectionValid True 15:48:48 - IsConnectionValid True 15:48:56 - IsConnectionValid True