Select a.[First Name],a.[Surname],
a.[Clock Number],a.[Cost Centre], b.Location,
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
left join [dbo].[T&A_Temp_Primetime] b
on a.[First Name]= b.[First Name]
and a.surname = b.surname
and a.[date] = b.[date]
Where a.[TimeCal] > 0
and b.[Hours] is null
order by a.[Cost Centre],[shift]
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.