ALTER PROCEDURE [dbo].[sp_SensorsStreamOutputInsert]
			@SerialNumber			NVARCHAR (50),

            @StreamProfile					NVARCHAR (50),
			@UDPAddress						NVARCHAR (50),
			@TimeChannelId					INT,
			@DataChannelId					INT,
			@TmNSConfig						NVARCHAR (50),
			@IRIGTimeDataPacketIntervalMs	INT,
			
			@LastModified			DATETIME,
			@LastModifiedBy			NVARCHAR (50),
			@UserTags				VARBINARY (MAX),  
			@Broken					BIT,
			@DoNotUse				BIT,         
			@new_id					INT OUTPUT,
			@errorNumber			INT OUTPUT,
			@errorMessage			NVARCHAR (255) OUTPUT
AS
BEGIN
	SET @errorNumber = 0 
	SET @errorMessage = space(0)
	
	DECLARE @SensorId AS INT
	DECLARE @SensorType AS TINYINT

	SELECT @SensorType = [TypeId] FROM [dbo].[SensorsType] WHERE [SensorType]='StreamOutput'

	INSERT INTO [dbo].[Sensors] ([SensorType], [SerialNumber]) VALUES (@SensorType, @SerialNumber)

	SELECT @SensorId = SCOPE_IDENTITY()

	INSERT INTO [dbo].[SensorsStreamOutput] ([SensorId], [StreamProfile], [UDPAddress], [TimeChannelId], [DataChannelId], [TmNSConfig], [IRIGTimeDataPacketIntervalMs], [LastModified], [LastModifiedBy], [UserTags], [Broken], [DoNotUse]) VALUES (@SensorId, CASE WHEN @StreamProfile='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE @StreamProfile END, @UDPAddress, @TimeChannelId, @DataChannelId, @TmNSConfig, @IRIGTimeDataPacketIntervalMs, @LastModified, @LastModifiedBy, @UserTags, @Broken, @DoNotUse)

	IF(@@error != 0)
	BEGIN
		SET @errorNumber = error_number()
		SET @errorMessage = error_message()
	END
	SET @new_id = @SensorId

END