23 lines
1.2 KiB
Plaintext
23 lines
1.2 KiB
Plaintext
CREATE PROCEDURE [dbo].[sp_SensorsStreamInputGet]
|
|
@Id INT = null,
|
|
@SerialNumber NVARCHAR (50) = null
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
IF( @Id IS NULL)
|
|
BEGIN
|
|
IF NULLIF(@SerialNumber, '') IS NULL
|
|
BEGIN
|
|
SELECT A.id, A.SerialNumber, B.UDPAddress, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamInput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamInput'
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
SELECT A.id, A.SerialNumber, B.UDPAddress, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamInput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamInput' AND A.SerialNumber=@SerialNumber
|
|
END
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
SELECT A.id, A.SerialNumber, B.UDPAddress, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamInput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamInput' AND A.id=@Id
|
|
END
|
|
END |