00:42:42 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:44 - IsConnectionValid True 00:42:45 - IsConnectionValid True 00:43:28 - IsConnectionValid True 00:43:37 - IsConnectionValid True 00:43:42 - IsConnectionValid True 00:43:42 - IsConnectionValid True 00:43:48 - IsConnectionValid True 00:43:51 - IsConnectionValid True 00:43:51 - 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 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:43:56 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:43:56 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:43:56 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:43:56 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 1088 WHERE LocationDef.TenantID =1 Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 1088 WHERE CustodyItemsDef.TenantID =1 Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =1088 Query 00:43:56 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:43:56 - IsConnectionValid True 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:43:56 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:43:56 - IsConnectionValid True 00:43:56 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:43:57 - IsConnectionValid True 00:43:57 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:43:57 - IsConnectionValid True 00:43:57 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:44:07 - IsConnectionValid True 00:44:10 - IsConnectionValid True 00:44:10 - 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 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:44:13 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:44:13 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:44:13 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:44:13 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 1087 WHERE LocationDef.TenantID =1 Query 00:44:13 - IsConnectionValid True 00:44:13 - IsConnectionValid True 00:44:13 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 1087 WHERE CustodyItemsDef.TenantID =1 Query 00:44:13 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =1087 Query 00:44:13 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:44:13 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:44:13 - IsConnectionValid True 00:44:13 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:44:57 - IsConnectionValid True 00:44:57 - 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 00:45:01 - IsConnectionValid True 00:45:01 - 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 Code =000112 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:45:02 - IsConnectionValid True 00:45:02 - IsConnectionValid True 00:45:02 - IsConnectionValid True 00:45:02 - IsConnectionValid True 00:45:02 - IsConnectionValid True 00:45:02 - IsConnectionValid True 00:45:02 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:45:02 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:45:02 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:45:02 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:45:02 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:45:03 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:45:03 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:45:03 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:03 - IsConnectionValid True 00:45:03 - IsConnectionValid True 00:45:03 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:03 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:03 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:45:03 - IsConnectionValid True 00:45:03 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:45:10 - IsConnectionValid True 00:45:10 - IsConnectionValid True 00:45:10 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:45:10 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:28 - IsConnectionValid True 00:45:28 - 2024-09-30 dateleft :: 09/30/2024 00:45:28 - IsConnectionValid True 00:45:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:45:31 - IsConnectionValid True 00:45:33 - IsConnectionValid True 00:45:33 - 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 00:45:40 - IsConnectionValid True 00:45:40 - 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 Code =000112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:45:42 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:45:42 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:45:42 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:45:42 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:45:42 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:45:42 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:45:42 - IsConnectionValid True 00:45:42 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:45:42 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - IsConnectionValid True 00:45:42 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:42 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:45:43 - IsConnectionValid True 00:45:43 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:45:43 - IsConnectionValid True 00:45:43 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:46:01 - IsConnectionValid True 00:46:01 - 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 Code =000112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:46:03 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:46:03 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:46:03 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:03 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:03 - IsConnectionValid True 00:46:04 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:46:04 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:46:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:04 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:46:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:46:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:46:04 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:46:04 - IsConnectionValid True 00:46:04 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:46:04 - IsConnectionValid True 00:46:04 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:46:04 - IsConnectionValid True 00:46:04 - IsConnectionValid True 00:46:04 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:46:04 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:46:04 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:46:04 - IsConnectionValid True 00:46:04 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:46:04 - IsConnectionValid True 00:46:04 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:46:05 - IsConnectionValid True 00:46:05 - IsConnectionValid True 00:46:05 - IsConnectionValid True 00:46:05 - IsConnectionValid True 00:46:05 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:46:05 - (1-gen-1002) : The given key was not present in the dictionary. 00:46:05 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:46:05 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:05 - IsConnectionValid True 00:47:05 - 2024-09-30 dateleft :: 09/30/2024 00:47:05 - IsConnectionValid True 00:47:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:47:09 - IsConnectionValid True 00:47:09 - IsConnectionValid True 00:47:09 - IsConnectionValid True 00:47:09 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 00:47:09 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:09 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:47:12 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 00:47:12 - IsConnectionValid True 00:47:12 - (1-gen-1002) : The given key was not present in the dictionary. 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:47:12 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:47:12 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:47:12 - IsConnectionValid True 00:47:12 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:47:12 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 00:47:12 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - IsConnectionValid True 00:47:12 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:12 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:12 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:12 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:12 - IsConnectionValid True 00:47:12 - (1-gen-1002) : The given key was not present in the dictionary. 00:47:12 - IsConnectionValid True 00:47:12 - (1-gen-1002) : The given key was not present in the dictionary. 00:47:14 - IsConnectionValid True 00:47:14 - 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 Code =000112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:47:17 - IsConnectionValid True 00:47:17 - 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 Code =000112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:47:18 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:47:18 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:47:18 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:47:18 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:47:18 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:18 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:18 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:47:18 - IsConnectionValid True 00:47:18 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:47:20 - IsConnectionValid True 00:47:20 - IsConnectionValid True 00:47:20 - IsConnectionValid True 00:47:20 - IsConnectionValid True 00:47:20 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:47:20 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:47:20 - (1-gen-1002) : The given key was not present in the dictionary. 00:47:20 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:48:30 - IsConnectionValid True 00:48:32 - IsConnectionValid True 00:48:32 - IsConnectionValid True 00:48:32 - IsConnectionValid True 00:48:32 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:48:32 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:48:32 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:50:38 - IsConnectionValid True 00:50:39 - IsConnectionValid True 00:50:39 - IsConnectionValid True 00:50:39 - IsConnectionValid True 00:50:39 - IsConnectionValid True 00:50:39 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:50:39 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:50:39 - (1-gen-1002) : The given key was not present in the dictionary. 00:50:39 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:50:52 - IsConnectionValid True 00:50:53 - IsConnectionValid True 00:50:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:51:01 - IsConnectionValid True 00:51:01 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:51:01 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:01 - (1-gen-1002) : The given key was not present in the dictionary. 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - IsConnectionValid True 00:51:01 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:51:01 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:51:01 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:51:01 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:51:01 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:51:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:51:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:51:02 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - IsConnectionValid True 00:51:02 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:02 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:02 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:51:02 - IsConnectionValid True 00:51:02 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:51:07 - IsConnectionValid True 00:51:07 - 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 Code =000112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:10 - IsConnectionValid True 00:51:10 - 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 Code =000112 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:51:11 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:51:11 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:51:11 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:51:11 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:51:11 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:11 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:51:11 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - IsConnectionValid True 00:51:11 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =13 Query 00:51:11 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:11 - IsConnectionValid True 00:51:11 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:11 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:51:12 - IsConnectionValid True 00:51:12 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:51:12 - IsConnectionValid True 00:51:12 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:51:13 - IsConnectionValid True 00:51:13 - IsConnectionValid True 00:51:13 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:51:13 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:51:13 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 00:51:20 - IsConnectionValid True 00:51:20 - 2024-09-06 dateleft :: 09/06/2024 00:51:20 - IsConnectionValid True 00:51:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:25 - IsConnectionValid True 00:51:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:32 - IsConnectionValid True 00:51:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 AND Code = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:33 - IsConnectionValid True 00:51:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 AND Code = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:51:36 - IsConnectionValid True 00:51:38 - IsConnectionValid True 00:51:38 - 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 00:51:42 - IsConnectionValid True 00:51:42 - 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 00:52:15 - IsConnectionValid True 00:52:15 - 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 Code =112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:52:17 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:52:17 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:52:17 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:52:17 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:52:17 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:52:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:52:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:52:17 - IsConnectionValid True 00:52:17 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - IsConnectionValid True 00:52:17 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:17 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:17 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:17 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:18 - IsConnectionValid True 00:52:18 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:52:18 - IsConnectionValid True 00:52:18 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:52:54 - IsConnectionValid True 00:52:54 - 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 Code =112 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:52:59 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 00:52:59 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:52:59 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:52:59 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:52:59 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 13 WHERE LocationDef.TenantID =1 Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 13 WHERE CustodyItemsDef.TenantID =1 Query 00:52:59 - IsConnectionValid True 00:52:59 - IsConnectionValid True 00:52:59 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:59 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:59 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 00:52:59 - IsConnectionValid True 00:52:59 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 00:53:00 - IsConnectionValid True 00:53:00 - IsConnectionValid True 00:53:00 - IsConnectionValid True 00:53:00 - IsConnectionValid True 00:53:00 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 00:53:00 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 00:53:00 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:53:00 - (1-gen-1002) : The given key was not present in the dictionary. 00:53:04 - IsConnectionValid True 00:53:04 - IsConnectionValid True 00:53:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:53:04 - IsConnectionValid True 00:53:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 AND Code = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:53:05 - IsConnectionValid True 00:53:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 AND Code = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:57:31 - IsConnectionValid True 00:57:35 - IsConnectionValid True 00:57:35 - 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 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:57:37 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:57:37 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 00:57:37 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:57:37 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - IsConnectionValid True 00:57:37 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - IsConnectionValid True 00:57:37 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:37 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 00:57:38 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 00:57:38 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - IsConnectionValid True 00:57:38 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:57:38 - IsConnectionValid True 00:57:38 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:57:38 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:57:38 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:58:15 - IsConnectionValid True 00:58:23 - IsConnectionValid True 00:58:23 - IsConnectionValid True 00:58:23 - IsConnectionValid True 00:58:23 - IsConnectionValid True 00:58:23 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 00:58:23 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 00:58:23 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 00:58:23 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 00:58:24 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:58:24 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 00:58:24 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 00:58:24 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - IsConnectionValid True 00:58:24 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:58:24 - IsConnectionValid True 00:58:24 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:58:24 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 00:58:24 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:06:23 - IsConnectionValid True 14:06:24 - IsConnectionValid True 14:06:24 - IsConnectionValid True 14:06:43 - IsConnectionValid True 14:06:43 - IsConnectionValid True 14:06:45 - IsConnectionValid True 14:06:48 - IsConnectionValid True 14:06:51 - IsConnectionValid True 14:06:51 - 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 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:06:53 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 14:06:53 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:06:53 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:06:53 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:06:53 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:06:53 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 1088 WHERE LocationDef.TenantID =1 Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 1088 WHERE CustodyItemsDef.TenantID =1 Query 14:06:53 - IsConnectionValid True 14:06:53 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =1088 Query 14:06:53 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:06:53 - IsConnectionValid True 14:06:53 - IsConnectionValid True 14:06:53 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:06:53 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:06:54 - IsConnectionValid True 14:06:54 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:06:54 - IsConnectionValid True 14:06:54 - IsConnectionValid True 14:06:54 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 14:06:54 - IsConnectionValid True 14:06:54 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 14:07:04 - IsConnectionValid True 14:07:06 - IsConnectionValid True 14:07:06 - 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 14:07:07 - IsConnectionValid True 14:07:07 - IsConnectionValid True 14:07:07 - IsConnectionValid True 14:07:07 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:07:07 - IsConnectionValid True 14:07:07 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:07:07 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:07:07 - IsConnectionValid True 14:07:07 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:07:08 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:07:08 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:07:08 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 1088 WHERE LocationDef.TenantID =1 Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 1088 WHERE CustodyItemsDef.TenantID =1 Query 14:07:08 - IsConnectionValid True 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =1088 Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:07:08 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:07:08 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 14:07:08 - IsConnectionValid True 14:07:08 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 14:07:10 - IsConnectionValid True 14:07:10 - SELECT DISTINCT * FROM vwEmployeesBanks WHERE TenantID = 1 AND TenantID = @val0 and EmpID = @val1 and UserID = @val2 Query 14:07:12 - IsConnectionValid True 14:07:12 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:15 - IsConnectionValid True 14:07:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 AND BankID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:07:38 - IsConnectionValid True 14:07:39 - IsConnectionValid True 14:07:39 - IsConnectionValid True 14:07:39 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:07:45 - IsConnectionValid True 14:07:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 AND BankID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:20:42 - IsConnectionValid True 14:20:44 - IsConnectionValid True 14:20:44 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:46 - IsConnectionValid True 14:20:53 - IsConnectionValid True 14:20:53 - 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 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:20:55 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:20:55 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:20:55 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:20:55 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:20:55 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:20:55 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:20:55 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:20:55 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:20:55 - IsConnectionValid True 14:20:55 - IsConnectionValid True 14:20:55 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:20:55 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:21:45 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:21:48 - IsConnectionValid True 14:21:48 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:21:48 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:21:48 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - IsConnectionValid True 14:21:48 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:48 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:21:48 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:48 - IsConnectionValid True 14:21:48 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:21:49 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:21:49 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:21:49 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:21:49 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:21:49 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - IsConnectionValid True 14:21:49 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:21:49 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:21:49 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:21:49 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:10 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:23:14 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:23:14 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:23:14 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:14 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:14 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:23:14 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - IsConnectionValid True 14:23:14 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:14 - IsConnectionValid True 14:23:14 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:14 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:28 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:23:31 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:23:31 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:23:31 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:31 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:31 - IsConnectionValid True 14:23:31 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:31 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:31 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:32 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:32 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:32 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:32 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:23:32 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:23:32 - IsConnectionValid True 14:23:32 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - IsConnectionValid True 14:23:32 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:32 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:32 - IsConnectionValid True 14:23:32 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:32 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:42 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:23:45 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:45 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:23:45 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:23:45 - IsConnectionValid True 14:23:45 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - IsConnectionValid True 14:23:45 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:45 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:45 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:23:45 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:14 - IsConnectionValid True 14:27:16 - IsConnectionValid True 14:27:16 - IsConnectionValid True 14:27:16 - IsConnectionValid True 14:27:16 - IsConnectionValid True 14:27:16 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:27:16 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:27:16 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:27:17 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:27:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:27:17 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - IsConnectionValid True 14:27:17 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:17 - IsConnectionValid True 14:27:17 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:17 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:17 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:54 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:27:57 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:27:57 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:27:57 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:27:57 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:27:57 - IsConnectionValid True 14:27:57 - IsConnectionValid True 14:27:57 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:27:57 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:57 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:27:57 - IsConnectionValid True 14:27:57 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:28:15 - IsConnectionValid True 14:28:17 - IsConnectionValid True 14:28:17 - IsConnectionValid True 14:28:17 - IsConnectionValid True 14:28:17 - IsConnectionValid True 14:28:17 - IsConnectionValid True 14:28:17 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:28:17 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:28:18 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:28:18 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:28:18 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:28:18 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:28:18 - IsConnectionValid True 14:28:18 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:28:18 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:52:44 - IsConnectionValid True 14:52:45 - IsConnectionValid True 14:52:45 - IsConnectionValid True 14:52:45 - IsConnectionValid True 14:52:45 - IsConnectionValid True 14:52:45 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:52:45 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:52:45 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:52:45 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:52:46 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:52:46 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:52:46 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:52:46 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:52:46 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - IsConnectionValid True 14:52:46 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:52:46 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:52:46 - IsConnectionValid True 14:52:46 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:52:46 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:52:46 - IsConnectionValid True 14:56:09 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:56:11 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:56:11 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:56:11 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:56:11 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:56:11 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:56:11 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:56:11 - IsConnectionValid True 14:56:11 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:56:11 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - IsConnectionValid True 14:56:11 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:56:11 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:56:11 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:56:11 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:56:11 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:36 - IsConnectionValid True 14:58:39 - IsConnectionValid True 14:58:39 - IsConnectionValid True 14:58:39 - IsConnectionValid True 14:58:39 - IsConnectionValid True 14:58:39 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:58:39 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:58:39 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:58:40 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:58:40 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:58:40 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:58:40 - IsConnectionValid True 14:58:40 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:58:40 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - IsConnectionValid True 14:58:40 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:40 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:40 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:40 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:52 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:58:54 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:58:54 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:58:54 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:58:54 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:58:54 - IsConnectionValid True 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:54 - IsConnectionValid True 14:58:54 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:58:54 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:03 - IsConnectionValid True 14:59:03 - 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 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:59:04 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:59:04 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:59:04 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:59:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:59:04 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:04 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:59:04 - IsConnectionValid True 14:59:04 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:59:04 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:04 - IsConnectionValid True 14:59:05 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:05 - IsConnectionValid True 14:59:05 - IsConnectionValid True 14:59:05 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:05 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:29 - IsConnectionValid True 14:59:31 - IsConnectionValid True 14:59:31 - IsConnectionValid True 14:59:31 - IsConnectionValid True 14:59:31 - IsConnectionValid True 14:59:31 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 14:59:31 - IsConnectionValid True 14:59:31 - SELECT DISTINCT * FROM VacationDays WHERE TenantID = 1 AND TenantID = @val0 AND FromCount <= @val1 AND ToCount >= @val2 Query 14:59:31 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 14:59:31 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 14:59:32 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:59:32 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 14:59:32 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 14:59:32 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 14:59:32 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 14:59:32 - IsConnectionValid True 14:59:32 - IsConnectionValid True 14:59:32 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:32 - IsConnectionValid True 14:59:32 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:32 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 14:59:32 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query