- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
Select a.[First Name],a.[Surname], a.[Clock Number],a.[Cost Centre], a.[shift], Convert(varchar,a.[Date],103) as [Date], a.[TimeCal] as [Losses Attendance Hours],b.[Hours] as [PrimetimeHours], a.[TimeCal] - b.[Hours] as [Difference] from [dbo].[T&A_Temp] a inner join [dbo].[T&A_Temp_Primetime] b on a. [First Name]= b.[First Name] and a.surname = b.surname Where a.[TimeCal] <> b.[Hours] and NOT Exists (select [first name],Surname from [T&A_Temp] group by [first name],Surname having count(*) > 30) order by a.[Cost Centre]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.