14:11:55 - IsConnectionValid True 14:11:55 - IsConnectionValid True 14:11:55 - IsConnectionValid True 14:12:01 - IsConnectionValid True 14:12:06 - IsConnectionValid True 14:12:06 - IsConnectionValid True 14:12:09 - IsConnectionValid True 14:12:11 - IsConnectionValid True 14:12:11 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:12:17 - IsConnectionValid True 14:12:17 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 14:12:18 - IsConnectionValid True 14:12:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:12:18 - IsConnectionValid True 14:12:18 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:12:20 - IsConnectionValid True 14:12:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,13,1) AS CreditForLastYear, dbo.web_get_vacationCredit('01/01/1900','01/01/1900',ID,13,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:12:20 - (1-gen-1004) : Invalid column name 'IsWorkInjury'. 14:15:13 - IsConnectionValid True 14:15:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,13,1) AS CreditForLastYear, dbo.web_get_vacationCredit('01/01/1900','01/01/1900',ID,13,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:15:13 - (1-gen-1004) : Cannot find either column "dbo" or the user-defined function or aggregate "dbo.web_get_vacationCredit", or the name is ambiguous. 14:47:10 - IsConnectionValid True 14:47:11 - IsConnectionValid True 14:47:11 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:22 - IsConnectionValid True 14:47:22 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 14:47:22 - IsConnectionValid True 14:47:22 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:23 - IsConnectionValid True 14:47:23 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:24 - IsConnectionValid True 14:47:24 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,14,1) AS CreditForLastYear FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:30 - IsConnectionValid True 14:47:36 - IsConnectionValid True 14:47:36 - IsConnectionValid True 14:47:40 - IsConnectionValid True 14:47:52 - IsConnectionValid True 14:47:53 - IsConnectionValid True 14:47:53 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:54 - IsConnectionValid True 14:47:54 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 14:47:54 - IsConnectionValid True 14:47:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:55 - IsConnectionValid True 14:47:55 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:47:57 - IsConnectionValid True 14:47:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,13,1) AS CreditForLastYear FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:47:58 - IsConnectionValid True 14:47:58 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:47:58 - IsConnectionValid True 14:47:58 - SELECT DISTINCT ID AS ID, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',1,ID,1) AS CreditForLastYear, dbo.web_get_vacationCredit('01/01/1900','01/01/1900',1,ID,1) AS VacationsCredit FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:47:58 - (1-gen-1002) : Cannot find either column "dbo" or the user-defined function or aggregate "dbo.web_get_vacationCredit", or the name is ambiguous. 14:51:48 - IsConnectionValid True 14:51:49 - IsConnectionValid True 14:51:49 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:51:51 - IsConnectionValid True 14:51:51 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 14:51:51 - IsConnectionValid True 14:51:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:51:52 - IsConnectionValid True 14:51:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 14:51:55 - IsConnectionValid True 14:51:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,14,1) AS CreditForLastYear FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:51:57 - IsConnectionValid True 14:51:57 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:51:57 - IsConnectionValid True 14:51:57 - SELECT DISTINCT ID AS ID, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',1,ID,1) AS CreditForLastYear FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 14:52:04 - IsConnectionValid True 14:52:04 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:04 - IsConnectionValid True 14:52:04 - SELECT DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:05 - IsConnectionValid True 14:52:05 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:05 - IsConnectionValid True 14:52:05 - SELECT DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:06 - IsConnectionValid True 14:52:06 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:06 - IsConnectionValid True 14:52:06 - SELECT DISTINCT OccasionDate AS OccasionDate FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 14:52:07 - IsConnectionValid True 14:52:15 - IsConnectionValid True