12:59:18 - IsConnectionValid True
12:59:19 - IsConnectionValid True
12:59:19 - IsConnectionValid True
12:59:24 - IsConnectionValid True
12:59:24 - IsConnectionValid True
12:59:28 - IsConnectionValid True
12:59:31 - IsConnectionValid True
13:21:00 - IsConnectionValid True
13:21:27 - IsConnectionValid True
13:21: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:21:33 - IsConnectionValid True
13:21: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:22:02 - IsConnectionValid True
13:22: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:22:08 - IsConnectionValid True
13:22:08 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:24:17 - IsConnectionValid True
13:24:28 - IsConnectionValid True
13:24: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:24:33 - IsConnectionValid True
13:24: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:26:38 - IsConnectionValid True
13:26:49 - IsConnectionValid True
13:26:49 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:26:53 - IsConnectionValid True
13:26: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:29:53 - IsConnectionValid True
13:30:08 - IsConnectionValid True
13:30:08 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:30:11 - IsConnectionValid True
13:30: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:32:43 - IsConnectionValid True
13:32:56 - IsConnectionValid True
13:32: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:32:59 - IsConnectionValid True
13:32: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:41:12 - IsConnectionValid True
13:41:23 - IsConnectionValid True
13:41: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:41:29 - IsConnectionValid True
13:41:29 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:42:09 - IsConnectionValid True
13:42: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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:42:13 - IsConnectionValid True
13:42:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND Name LIKE @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:42:17 - IsConnectionValid True
13:42: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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:43:51 - IsConnectionValid True
13:43:54 - IsConnectionValid True
13:43: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:43:59 - IsConnectionValid True
13:43: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:44:02 - IsConnectionValid True
13:44: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:45:41 - IsConnectionValid True
13:45:44 - IsConnectionValid True
13:45: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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:45:46 - IsConnectionValid True
13:45: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:47:01 - IsConnectionValid True
13:47:10 - IsConnectionValid True
13:47: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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:11 - IsConnectionValid True
13:47: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:47:18 - IsConnectionValid True
13:47:24 - IsConnectionValid True
13: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  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:47:25 - IsConnectionValid True
13:47: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:12:53 - IsConnectionValid True
14:12: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
14:33:33 - IsConnectionValid True
14:33:40 - IsConnectionValid True
14:33: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:33:45 - IsConnectionValid True
14:33: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:34:01 - IsConnectionValid True
14:34:07 - IsConnectionValid True
14:34:07 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:34:11 - IsConnectionValid True
14:34: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:37:24 - IsConnectionValid True
14:37:29 - IsConnectionValid True
14:37:29 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:37:37 - IsConnectionValid True
14:37: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:37:46 - IsConnectionValid True
14:37: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   AND ID IN (SELECT EmployeeID FROM DailyTransactionEntry WHERE Year(TransactionDate)=2023 AND MONTH(TrnasactionDate)=1)  ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
14:37:46 - (1-gen-1002) : Invalid column name 'TrnasactionDate'.
14:39:39 - IsConnectionValid True
14:39:48 - IsConnectionValid True
14:39: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:39:51 - IsConnectionValid True
14:39: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:40:01 - IsConnectionValid True
14:40: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   AND ID IN (SELECT EmployeeID FROM DailyTransactionEntry WHERE Year(TransactionDate)=2023 AND MONTH(TransactionDate)=1)  ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
14:42:22 - IsConnectionValid True
14:42:32 - IsConnectionValid True
14:42: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:42:37 - IsConnectionValid True
14:42: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:42:46 - IsConnectionValid True
14:42: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   AND ID IN (SELECT EmployeeID FROM DailyTransactionEntry WHERE Year(TransactionDate)=2023 AND MONTH(TransactionDate)=1 AND TransactionID=4)  ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:05:39 - IsConnectionValid True
15:05:53 - IsConnectionValid True
15:05: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:05:59 - IsConnectionValid True
15:05: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:06:09 - IsConnectionValid True
15:06:09 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:08:39 - IsConnectionValid True
15:08:47 - IsConnectionValid True
15:08: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:08:52 - IsConnectionValid True
15:08: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:09:04 - IsConnectionValid True
15:09:04 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:22:54 - IsConnectionValid True
15:23:00 - IsConnectionValid True
15:23: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:23:08 - IsConnectionValid True
15:23:08 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:23:17 - IsConnectionValid True
15:23:17 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:23:37 - IsConnectionValid True
15:23:43 - IsConnectionValid True
15:23: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:23:47 - IsConnectionValid True
15:23: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:23:55 - IsConnectionValid True
15:23:55 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:31:27 - IsConnectionValid True
15:31:37 - IsConnectionValid True
15:31: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:31:41 - IsConnectionValid True
15:31: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:31:50 - IsConnectionValid True
15:31:50 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:37:34 - IsConnectionValid True
15:37:45 - IsConnectionValid True
15:37: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:37:51 - IsConnectionValid True
15:37: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:37:53 - IsConnectionValid True
15:37: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:38:01 - IsConnectionValid True
15:38:01 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:38:29 - IsConnectionValid True
15:38:36 - IsConnectionValid True
15:38:36 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:38:38 - IsConnectionValid True
15:38: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:38:49 - IsConnectionValid True
15:38:49 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:39:47 - IsConnectionValid True
15:39:55 - IsConnectionValid True
15: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:39:58 - IsConnectionValid True
15:39:58 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:07 - IsConnectionValid True
15:40:07 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:40:41 - IsConnectionValid True
15:40:43 - IsConnectionValid True
15:40:49 - IsConnectionValid True
15:40:49 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:53 - IsConnectionValid True
15:40: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:41:00 - IsConnectionValid True
15:41:00 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:42:02 - IsConnectionValid True
15:42:11 - IsConnectionValid True
15:42: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:42:15 - IsConnectionValid True
15:42:15 - 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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:42:21 - IsConnectionValid True
15:42:21 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:43:05 - IsConnectionValid True
15:43:14 - IsConnectionValid True
15:43: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:43:17 - IsConnectionValid True
15:43: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:43:25 - IsConnectionValid True
15:43:25 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
15:48:14 - IsConnectionValid True
15:53:50 - IsConnectionValid True
15:53: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:53:54 - IsConnectionValid True
15:53: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 IsSalaryDetails = @val2 and IsNotManualEntry = @val3 and IsReserve = @val4 and Loans = @val5 and IsInsurance = @val6  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Name LIKE @val8  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:54:00 - IsConnectionValid True
15:54:00 - SELECT * FROM HRMS_vwTransactionEntryPerMonth 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 and Year = @val8 and Month = @val9 and TransactionID = @val10 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query