USE Device
GO
DECLARE @deviceMinBatt TABLE
(
IMEI VARCHAR (50),
BattDate DATETIME,
MinBatt FLOAT,
[State] VARCHAR (50)
)
DECLARE @deviceMaxBatt TABLE
(
IMEI VARCHAR (50),
BattDate DATETIME,
MaxBatt FLOAT,
[State] VARCHAR (50)
)
DECLARE @deviceState TABLE
(
IMEI VARCHAR(50),
[State] VARCHAR(50)
)
DECLARE @deviceValid TABLE
(
IMEI VARCHAR (50),
[State] VARCHAR (50)
)
DECLARE...