11:43:12 - IsConnectionValid True
11:43:49 - IsConnectionValid True
11:43:53 - IsConnectionValid True
11:43:53 - IsConnectionValid True
11:43:56 - IsConnectionValid True
11:44:00 - IsConnectionValid True
11:44:09 - IsConnectionValid True
11:44: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:44:34 - IsConnectionValid True
11:44: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:44:45 - IsConnectionValid True
11:44: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:45:41 - IsConnectionValid True
11:45: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:46:03 - IsConnectionValid True
11:46: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:47:01 - IsConnectionValid True
11:47: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:47:52 - IsConnectionValid True
11:47: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:49:40 - IsConnectionValid True
11:49: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:49:42 - IsConnectionValid True
11:49:42 - 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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:49:44 - IsConnectionValid True
11:49: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:54:28 - IsConnectionValid True
11:54: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:54:31 - IsConnectionValid True
11:54:31 - 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
11:54:31 - IsConnectionValid True
11:54:33 - IsConnectionValid True
11:54: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:54:38 - IsConnectionValid True
11:54: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, IsTransIsNeededAccNo AS IsTransIsNeededAccNo 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
11:54:46 - IsConnectionValid True
11:54:46 - 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
11:54:46 - IsConnectionValid True
11:56:04 - IsConnectionValid True
11:56:15 - IsConnectionValid True