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]
|SQL Server stored proc||2||13|
|SQL - How to list all tables participating in a query||7||43|
|Whats wrong in the below query? Any help would be appreciated...||2||15|
|SQL bit field not working as expected||3||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!