11:39:32 - IsConnectionValid True
11:39:32 - IsConnectionValid True
11:39:43 - IsConnectionValid True
11:39:48 - IsConnectionValid True
11:39:48 - 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:45:59 - IsConnectionValid True
11:46:01 - IsConnectionValid True
11:46:02 - IsConnectionValid True