USE [v710_kursk_20150820]
GO
-- Object:  StoredProcedure [dbo].[ext_Device_SelectBySystem]    Script Date: 03.03.2016 18:09:19 /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

alter PROCEDURE [dbo].[ext_Device_SelectBySystem]  @idSystem uniqueidentifier
AS  
BEGIN
SELECT d.Name AS deviceName, 
		 DT.Name AS deviceTypeName,
		 o.Name AS objectName,
		 ds.Online,
		dat.DisplayValue
FROM ext_Device AS d  where  d.idSystem = @idSystem
left JOIN ext_DeviceType AS dt ON d.idDeviceType = dt.idDeviceType
LEFT JOIN obj_Object AS o ON d.idObject = o.idObject
left JOIN ext_DeviceStatus AS ds  ON d.idDevice = ds.idDevice AND ds.StatusPeriod = 0
left JOIN  ext_Data AS dat ON d.idDevice = dat.idDevice
end

USE [v710_kursk_20150820]
GO
-- Object:  StoredProcedure [dbo].[ext_Device_SelectBySystem]    Script Date: 03.03.2016 18:09:19 /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

alter PROCEDURE [dbo].[ext_Device_SelectBySystem]  @idSystem uniqueidentifier
AS  
BEGIN
SELECT d.Name AS deviceName, 
		 DT.Name AS deviceTypeName,
		 o.Name AS objectName,
		 ds.Online,
		dat.DisplayValue
FROM ext_Device AS d  
    left JOIN ext_DeviceType AS dt ON d.idDeviceType = dt.idDeviceType
    LEFT JOIN obj_Object AS o ON d.idObject = o.idObject
    left JOIN ext_DeviceStatus AS ds  ON d.idDevice = ds.idDevice AND ds.StatusPeriod = 0
    left JOIN  ext_Data AS dat ON d.idDevice = dat.idDevice
where  d.idSystem = @idSystem
end