Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
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]
|How to count the days a record spends in a step||21||49|
|SQL Server 2008 R2, need a pivot/cross tab query...||4||26|
|Accessing variables in MySQL query||4||21|
|SQL - Curser to do an insert based on a select||2||6|