23 lines
1.5 KiB
Plaintext
23 lines
1.5 KiB
Plaintext
|
CREATE PROCEDURE [dbo].[sp_SensorsStreamOutputGet]
|
||
|
|
@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.StreamProfile, B.UDPAddress, B.TimeChannelId, B.DataChannelId, B.TmNSConfig, B.IRIGTimeDataPacketIntervalMs, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamOutput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamOutput'
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
SELECT A.id, A.SerialNumber, B.StreamProfile, B.UDPAddress, B.TimeChannelId, B.DataChannelId, B.TmNSConfig, B.IRIGTimeDataPacketIntervalMs, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamOutput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamOutput' AND A.SerialNumber=@SerialNumber
|
||
|
|
END
|
||
|
|
END
|
||
|
|
ELSE
|
||
|
|
BEGIN
|
||
|
|
SELECT A.id, A.SerialNumber, B.StreamProfile, B.UDPAddress, B.TimeChannelId, B.DataChannelId, B.TmNSConfig, B.IRIGTimeDataPacketIntervalMs, B.LastModified, B.LastModifiedBy, B.UserTags, B.Broken, B.DoNotUse FROM [dbo].[Sensors] AS A INNER JOIN [dbo].[SensorsStreamOutput] AS B ON A.id=B.SensorId INNER JOIN [dbo].SensorsType AS C ON A.SensorType=C.TypeId WHERE C.SensorType='StreamOutput' AND A.id=@Id
|
||
|
|
END
|
||
|
|
END
|