Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
DECLARE @SENSORName as NVARCHAR; DECLARE @SENSORNUm as INT; DECLARE @TEMP as SMALLINT; DECLARE @Day as TINYINT; DECLARE @Hour as TINYINT; DECLARE @MinTemp as SMALLINT; DECLARE @MaxTemp as SMALLINT; SET @SENSORNum = 0; SET @Day = 1; SET @Hour = 1; SET @MinTemp = -80; SET @MaxTemp = 135; SET @TEMP = @MinTemp; SET @SENSORName = (SELECT MIN([SENSOR_ID]) from SENSOR where @SENSORNum < ID) WHILE @SENSORName is not null BEGIN INSERT INTO [Hourly]([SENSOR],[TEMP],[Day],[Hour]) VALUES(@SENSORName, @TEMP, @Day, @Hour) SET @Hour = CASE WHEN @Hour = 24 THEN @Hour = 1 SET @Day = CASE( WHEN @Day = 7 THEN SET @Day = 1 ELSE SET @Day = @day + 1 ELSE SET @Hour = @Hour + 1 END;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.