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.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
DECLARE @sessionDate DATE SET @sessionDate = '2016-10-23' SELECT count(*) as cnt FROM ( SELECT WeekStart = DATEADD(dd, -(DATEPART(dw, convert(date,SU.sessionStart,120))-1), convert(date,SU.sessionStart,120)) , WeekEnd = DATEADD(dd, 7-(DATEPART(dw, convert(date,SU.sessionStart,120))), convert(date,SU.sessionStart,120)) , CountID = Count(distinct S.sessionKey) FROM session S INNER JOIN sessionUnit SU on SU.sessionKey= S.sessionKey INNER JOIN product P on p.productKey = S.productKey CROSS APPLY ( SELECT item AS SPLITLOCATIONKEY from DelimitedSplit8K(S.locationKeyList, ',') )as ca INNER JOIN location AS L2 ON CA.SplitLocationKey = L2.LocationKey AND (L2.locationKey in (34,150) OR S.locationKey in (34,150)) WHERE SU.instructorKey = 2644 AND convert(DATE,su.sessionStart) > DateAdd("d",45,getDate()) AND convert(DATE,su.sessionStart) < DateAdd("d",91,getDate()) and datepart(dw, Su.sessionStart) in (1,7) and P.productKey in (2,4) AND DatePart(hour, su.sessionStart) between 8 and 11 GROUP BY Su.sessionStart )T WHERE @sessionDate BETWEEN T.WeekStart AND T.WeekEnd GRoup By T.WeekStart,T.WeekEnd,T.CountID
|Using SQL*PLUS issue with where statement with trunc function||3||27|
|Stored Proc - Rewrite||42||56|
|Solar Winds can't see SQL Server Express||17||31|
|SQL Error when trigger fires in SQL Server 2008 R2||6||13|