ALTER PROCEDURE [dbo].[sp_GroupChannelSettingsGet] @ChannelId BIGINT AS BEGIN SET NOCOUNT ON; SELECT SettingId, CASE WHEN SettingValue='UART_STREAM' THEN 'CH10_ANALOG_2HDR' ELSE SettingValue END as SettingValue FROM [dbo].[GroupChannelSettings] WHERE [ChannelId]=@ChannelId AND SettingId <> (SELECT Id FROM ChannelSettings WHERE SettingName = 'BridgeType') END