ALTER 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, CASE WHEN B.StreamProfile='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE B.StreamProfile END as [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, CASE WHEN B.StreamProfile='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE B.StreamProfile END as [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, CASE WHEN B.StreamProfile='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE B.StreamProfile END as [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