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.
CREATE PROCEDURE GetSensorSummary @SensorID int, @BegDate datetime, @EndDate datetime, @SensorDescription nvarchar(127) out, @MaxValue double out, @MaxTime datetime out, @MinValue double out, @MinTime datetime out AS BEGIN -- put the description from this query in @SensorDescription -- which I could do like this if only getting one value (I actually want to grab more than one): SET @SensorDescription = SELECT Description FROM SensorDef WHERE SensorID=@SensorID -- the queries below would also contain the date criteria in the WHERE clause (left out for brevity) SELECT TOP 1 DataValue, DataTime FROM SensorData WHERE SensorID=@SensorID ORDER BY DataValue DESC -- want to set @MaxValue=DataValue and @MaxTime=DataTime SELECT TOP 1 DataValue, DataTime FROM SensorData WHERE SensorID=@SensorID ORDER BY DataValue ASC -- want to set @MinValue=DataValue and @MinTime=DataTime END GO
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!