08:35:01 - IsConnectionValid True 08:35:08 - IsConnectionValid True 08:35:09 - IsConnectionValid True 08:35:15 - IsConnectionValid True 08:35:15 - IsConnectionValid True 08:35:19 - IsConnectionValid True 08:35:22 - IsConnectionValid True 08:35:34 - IsConnectionValid True 08:35:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 08:35:35 - IsConnectionValid True 08:35:35 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:35:35 - IsConnectionValid True 08:35:35 - SELECT DISTINCT * 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(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 08:35:37 - IsConnectionValid True 08:35:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 08:35:38 - IsConnectionValid True 08:35:38 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:35:38 - IsConnectionValid True 08:35:38 - SELECT DISTINCT * 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(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 08:35:41 - IsConnectionValid True 08:35:41 - (2-payroll-0010002) : Invalid column name 'TenantID'. 08:35:41 - IsConnectionValid True 08:35:41 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:35:41 - IsConnectionValid True 08:35:41 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:35:41 - IsConnectionValid True 08:35:41 - SELECT DISTINCT * 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(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 08:35:55 - IsConnectionValid True 08:35:55 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 08:35:55 - IsConnectionValid True 08:39:40 - IsConnectionValid True 08:39:48 - IsConnectionValid True 08:39:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwTransactionsWithSecurity WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5 and Sign = @val6 and IsReturnEffect = @val7 and IsSalaryDetails = @val8 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 08:39:50 - IsConnectionValid True 08:39:50 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:39:50 - IsConnectionValid True 08:39:50 - SELECT DISTINCT * 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(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 08:39:52 - IsConnectionValid True 08:39:52 - (2-payroll-0010002) : Invalid column name 'TenantID'. 08:39:52 - IsConnectionValid True 08:39:52 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:39:52 - IsConnectionValid True 08:39:52 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 08:39:52 - IsConnectionValid True 08:39:52 - SELECT DISTINCT * 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(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 08:40:01 - IsConnectionValid True 08:40:01 - SELECT DISTINCT * FROM DailyTransactionEntry WHERE TenantID = 1 AND TenantID = @val0 and TransactionID = @val1 and Month(TransactionDate) = @val2 and Year(TransactionDate) = @val3 and EmployeeID = @val4 Query 08:40:01 - IsConnectionValid True 09:06:18 - IsConnectionValid True 09:06:22 - IsConnectionValid True 09:06:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:07:15 - IsConnectionValid True 09:07:20 - IsConnectionValid True 09:07:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:11:37 - IsConnectionValid True 09:11:41 - IsConnectionValid True 09:11:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:21:31 - IsConnectionValid True 09:21:35 - IsConnectionValid True 09:21:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM vwproject WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:21:43 - IsConnectionValid True 09:21:43 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =1 or 1 =0) and (DepartmentID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:21:51 - IsConnectionValid True 09:21:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =1 or 1 =0) and (DepartmentID =9 or 9 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:21:54 - IsConnectionValid True 09:21:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =1 or 1 =0) and (DepartmentID =9 or 9 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:21:59 - IsConnectionValid True 09:21:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM VWDEPARTMENTS WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =1 or 1 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 09:22:10 - IsConnectionValid True 09:22:10 - (2-payroll-0010002) : Invalid column name 'TenantID'. 09:22:10 - IsConnectionValid True 09:22:10 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 09:22:10 - IsConnectionValid True 09:22:10 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 09:22:10 - IsConnectionValid True 09:22:10 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =undefined or undefined=0) and (DepartmentID =undefined or undefined=0) and (SectionID =undefined or undefined=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 09:22:11 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 09:22:14 - IsConnectionValid True 09:22:14 - (2-payroll-0010002) : Invalid column name 'TenantID'. 09:22:14 - IsConnectionValid True 09:22:14 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 09:22:14 - IsConnectionValid True 09:22:14 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 09:22:14 - IsConnectionValid True 09:22:14 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =undefined or undefined=0) and (DepartmentID =undefined or undefined=0) and (SectionID =undefined or undefined=0) and cast(Code as decimal(20,0)) >= @val6 and cast(Code as decimal(20,0)) <= @val7 ORDER BY Name Query 09:22:14 - (1-gen-1002) : Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. Invalid column name 'undefined'. 11:19:58 - IsConnectionValid True 11:22:02 - IsConnectionValid True 11:22:07 - IsConnectionValid True 11:22:07 - 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:22:09 - IsConnectionValid True 11:22:09 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:22:09 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:22:11 - IsConnectionValid True 11:22:11 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:22:11 - IsConnectionValid True 11:22:11 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:22:11 - IsConnectionValid True 11:22:11 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:22:11 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:28:19 - IsConnectionValid True 11:28:27 - IsConnectionValid True 11:28:31 - IsConnectionValid True 11:28:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:28:34 - IsConnectionValid True 11:28:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:28:37 - IsConnectionValid True 11:28:39 - IsConnectionValid True 11:28:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:44:03 - IsConnectionValid True 11:44:08 - IsConnectionValid True 11:44:14 - IsConnectionValid True 11:44:14 - 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:44:16 - IsConnectionValid True 11:44:16 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:44:16 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:44:17 - IsConnectionValid True 11:44:17 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:44:17 - IsConnectionValid True 11:44:17 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:44:17 - IsConnectionValid True 11:44:17 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:44:17 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:44:46 - IsConnectionValid True 11:44:52 - IsConnectionValid True 11:44:52 - 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:44:54 - IsConnectionValid True 11:44:54 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:44:54 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:44:55 - IsConnectionValid True 11:44:55 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:44:55 - IsConnectionValid True 11:44:55 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:44:55 - IsConnectionValid True 11:44:55 - SELECT DISTINCT * 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:44:55 - (1-gen-1002) : ORDER BY items must appear in the select list if SELECT DISTINCT is specified. 11:46:00 - IsConnectionValid True 11:46:04 - IsConnectionValid True 11:46:04 - 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:46:06 - IsConnectionValid True 11:46:06 - 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:46:06 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 11:46:06 - IsConnectionValid True 11:46:06 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:46:06 - IsConnectionValid True 11:46:06 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:46:06 - IsConnectionValid True 11:46:06 - 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 dateleft = @val8 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:46:06 - (1-gen-1002) : Conversion failed when converting date and/or time from character string. 11:48:01 - IsConnectionValid True 11:48:05 - IsConnectionValid True 11:48:05 - 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:48:06 - IsConnectionValid True 11:48:06 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 11:48:07 - IsConnectionValid True 11:48:07 - (2-payroll-0010002) : Invalid column name 'TenantID'. 11:48:07 - IsConnectionValid True 11:48:07 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 11:48:07 - IsConnectionValid True 11:48:07 - 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:49:13 - IsConnectionValid True 13:53:59 - IsConnectionValid True 13:54:04 - IsConnectionValid True 13:54:04 - 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 13:54:05 - IsConnectionValid True 13:54:05 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:54:06 - IsConnectionValid True 13:54:06 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:54:06 - IsConnectionValid True 13:54:06 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:54:06 - IsConnectionValid True 13:54:06 - 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:54:25 - IsConnectionValid True 13:54:29 - IsConnectionValid True 13:54:29 - 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 13:54:30 - IsConnectionValid True 13:54:30 - 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:54:31 - IsConnectionValid True 13:54:31 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:54:31 - IsConnectionValid True 13:54:31 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:54:31 - IsConnectionValid True 13:54:31 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:55:12 - IsConnectionValid True 13:55:17 - IsConnectionValid True 13:55:17 - 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 13:55:18 - IsConnectionValid True 13:55:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:55:18 - IsConnectionValid True 13:55:18 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:55:18 - IsConnectionValid True 13:55:18 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:55:18 - IsConnectionValid True 13:55:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:56:47 - IsConnectionValid True 13:56:52 - IsConnectionValid True 13:56:52 - 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 13:56:52 - IsConnectionValid True 13:56:52 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:56:53 - IsConnectionValid True 13:56:53 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:56:53 - IsConnectionValid True 13:56:53 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:56:53 - IsConnectionValid True 13:56:53 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:57:45 - IsConnectionValid True 13:57:45 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:57:45 - IsConnectionValid True 13:57:45 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:57:45 - IsConnectionValid True 13:57:45 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:58:39 - IsConnectionValid True 13:58:47 - IsConnectionValid True 13:58:47 - 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 13:58:48 - IsConnectionValid True 13:58:48 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 13:58:50 - IsConnectionValid True 13:58:50 - (2-payroll-0010002) : Invalid column name 'TenantID'. 13:58:50 - IsConnectionValid True 13:58:50 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 13:58:50 - IsConnectionValid True 13:58:50 - 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:00:02 - IsConnectionValid True 14:00:06 - IsConnectionValid True 14:00:06 - 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 14:00:07 - IsConnectionValid True 14:00:07 - 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:00:08 - IsConnectionValid True 14:00:08 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:00:08 - IsConnectionValid True 14:00:08 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:00:08 - IsConnectionValid True 14:00:08 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:00:47 - IsConnectionValid True 14:00:53 - IsConnectionValid True 14:00:53 - 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 14:00:54 - IsConnectionValid True 14:00:54 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:00:57 - IsConnectionValid True 14:00:57 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:00:57 - IsConnectionValid True 14:00:57 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:00:57 - IsConnectionValid True 14:00:57 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:01:18 - IsConnectionValid True 14:01:23 - IsConnectionValid True 14:01:23 - 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 14:01:23 - IsConnectionValid True 14:01:23 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:01:25 - IsConnectionValid True 14:01:25 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:01:25 - IsConnectionValid True 14:01:25 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:01:25 - IsConnectionValid True 14:01: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:02:52 - IsConnectionValid True 14:02:56 - IsConnectionValid True 14:02:56 - 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 14:02:57 - IsConnectionValid True 14:02:57 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:02:58 - IsConnectionValid True 14:02:58 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:02:58 - IsConnectionValid True 14:02:58 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:02:58 - IsConnectionValid True 14:02:58 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:03:18 - IsConnectionValid True 14:03:38 - IsConnectionValid True 14:03:38 - 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 14:03:39 - IsConnectionValid True 14:03:39 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:03:40 - IsConnectionValid True 14:03:40 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:03:40 - IsConnectionValid True 14:03:40 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:03:40 - IsConnectionValid True 14:03:40 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:05:05 - IsConnectionValid True 14:05:09 - IsConnectionValid True 14:05:10 - 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 14:05:11 - IsConnectionValid True 14:05:11 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:05:12 - IsConnectionValid True 14:05:12 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:05:12 - IsConnectionValid True 14:05:12 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:05:12 - IsConnectionValid True 14:05:12 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:07:09 - IsConnectionValid True 14:07:17 - IsConnectionValid True 14:07:17 - 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 14:07:18 - IsConnectionValid True 14:07:18 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:07:18 - IsConnectionValid True 14:07:19 - (2-payroll-0010002) : Invalid column name 'TenantID'. 14:07:19 - IsConnectionValid True 14:07:19 - SELECT DISTINCT DivisionFactor AS DivisionFactor, FromDate AS FromDate, ToDate AS ToDate FROM Calculationperiods WHERE TenantID = 1 AND TenantID = @val0 and MonthCode = @val1 Query 14:07:19 - IsConnectionValid True 14:07:19 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:21:49 - IsConnectionValid True 14:21:58 - IsConnectionValid True 14:21:58 - 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 14:21:59 - IsConnectionValid True 14:21:59 - SELECT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0)) Query 14:22:38 - IsConnectionValid True 14:22:43 - IsConnectionValid True 14:22:43 - 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 14:22:44 - IsConnectionValid True 14:22:44 - 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