Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.
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]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Options for Linking SQL tables to Access 2013||9||43|
|SQL Query that uses count(*) over, possible to use distinct?||18||49|
|using a SELECT statement in a THEN of a CASE statement.||5||15|
|T-SQL: How to extract records into a new table||7||22|