09:42:19 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:43:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:46:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:51:31 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:51:43 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:05 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:17 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:21 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:24 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:28 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:52:50 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:54:11 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:54:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:55:06 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
09:55:15 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM Projects  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:05:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:05:37 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:16:31 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
10:16:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:42:39 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
10:42:39 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:42:39 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:42:44 - SELECT  DISTINCT OrderNo AS OrderNo, TransType AS TransType FROM TransactionsDef WHERE TenantID = 1 AND   OrderNo = @val0 and TenantID = @val1 and TransType = @val2 and ID <> @val3  Query
10:42:45 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM TransactionsDef  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:51:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Name_E AS Name_E FROM VOU001    ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:51:10 - (1-gen-1004) : Invalid object name 'VOU001'.
10:51:10 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Name_E AS Name_E FROM VOU001    ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:51:10 - (1-gen-1004) : Invalid object name 'VOU001'.
11:09:54 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   (DateLeft ='01/01/1900' or (MONTH(DateleftTemp)> 10 AND YEAR(DateleftTemp) = 2021) OR (YEAR(DateleftTemp) > 2021)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:10:02 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:10:25 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:27 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:28 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:28 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:28 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:30 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:10:34 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:36 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:37 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:38 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:38 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:41 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:10:41 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:10:41 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:10:41 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:10:41 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:10:41 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:10:41 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:10:41 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:10:43 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:44 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:45 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:10:45 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:10:45 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:10:46 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:10:46 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:10:46 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:10:46 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:10:46 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:10:50 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:10:54 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:56 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:57 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:57 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:10:58 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:10:58 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:10:58 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:10:58 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:11:21 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:11:24 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:12:01 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:12:03 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:12:14 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:12:14 - SELECT  DISTINCT * FROM FinancialYearSettings WHERE TenantID = 1 AND   TenantID = @val0 and MonthID = @val1 and YearNo = @val2  Query
11:12:14 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:12:14 - SELECT  DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND   TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2  Query
11:12:14 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:12:14 - SELECT  DISTINCT * FROM VwTransactionForSalCal WHERE  TenantID = @val0 and Month(TransactionDate) = @val1 and Year(TransactionDate) = @val2 and Posted = @val3 and IsSalarydetails = @val4 and IsReserve = @val5 and Loans = @val6 and IsInsurance = @val7 and MotherVacDeduct = @val8 and (DateLeftTemp ='01/01/1900' or (Month(DateleftTemp)>10 AND Year(DateleftTemp)=2021) or (Year(DateleftTemp)>2021))  Query
11:12:14 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:12:14 - SELECT  DISTINCT * FROM Employees WHERE TenantID = 1 AND   TenantID = @val0 and Code = @val1  Query
11:12:24 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:12:26 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:12:26 - (2-payroll-0010018) : Invalid column name 'TenantID'.
11:13:15 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow