14:25:19 - IsConnectionValid True
14:25:19 - (1-gen-1002) : Object reference not set to an instance of an object.
14:25:20 - IsConnectionValid True
14:25:20 - (1-gen-1004) : Object reference not set to an instance of an object.
14:26:49 - IsConnectionValid True
14:26:49 - (1-gen-1002) : Object reference not set to an instance of an object.
14:26:49 - IsConnectionValid True
14:26:49 - (1-gen-1004) : Object reference not set to an instance of an object.
14:27:33 - IsConnectionValid True
14:27:33 - (1-gen-1002333) : Object reference not set to an instance of an object.
14:27:34 - IsConnectionValid True
14:27:34 - (1-gen-1004) : Object reference not set to an instance of an object.
14:28:47 - IsConnectionValid True
14:29:00 - IsConnectionValid True
14:29:00 - (1-gen-1002333) : Object reference not set to an instance of an object.
14:29:01 - IsConnectionValid True
14:29:01 - (1-gen-1004) : Object reference not set to an instance of an object.
14:30:19 - IsConnectionValid True
14:30:31 - IsConnectionValid True
14:30:31 - IsConnectionValid True
14:30:31 - 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, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees  WHERE  TenantID = 1 AND   UserID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:30:32 - querypaging
14:31:24 - IsConnectionValid True
14:31:32 - IsConnectionValid True
14:31:32 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
14:31:32 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASCquery
14:31:32 - IsConnectionValid True
14:31:32 - 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, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees  WHERE  TenantID = 1 AND   TenantID = @val0 AND UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:31:33 - querypaging
14:32:41 - IsConnectionValid True
14:32:49 - IsConnectionValid True
14:32:49 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
14:32:50 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASCquery
14:32:50 - IsConnectionValid True
14:32:50 - 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, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees  WHERE  TenantID = 1 AND   TenantID = @val0 AND UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:32:50 - querypaging
14:33:48 - IsConnectionValid True
14:34:17 - IsConnectionValid True
14:34:17 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
14:34:18 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASCquery
14:34:18 - IsConnectionValid True
14:34:18 - 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, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees  WHERE  TenantID = 1 AND   TenantID = @val0 AND UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:34:19 - querypaging
14:35:15 - IsConnectionValid True
14:35:23 - IsConnectionValid True
14:35:23 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
14:35:23 - SELECT ID AS ID, Code AS Code, Name AS Name, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees WHERE  TenantID = @val0 AND UserID = @val1 AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASCquery
14:35:24 - IsConnectionValid True
14:35:24 - 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, isNOTCalculation AS isNOTCalculation, DepartmentName AS DepartmentName, SectionName AS SectionName, JobName AS JobName, StopSalaryReason AS StopSalaryReason, ISNULL((select Top 1 LogFileStopSalaryCalc.StopDate From LogFileStopSalaryCalc where LogFileStopSalaryCalc.EmployeeID=VwEmployees.ID   order by LogFileStopSalaryCalc.StopDate DESC),01/01/1900) AS StopDate FROM VwEmployees  WHERE  TenantID = 1 AND   TenantID = @val0 AND UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:35:24 - querypaging