ALTER PROCEDURE [dbo].[sp_ChannelSettingsGet_92] @Id int = NULL, @SettingName NVARCHAR (255) = NULL AS BEGIN SET NOCOUNT ON; IF (@Id IS NOT NULL) OR (@SettingName IS NOT NULL) BEGIN IF (@Id IS NULL) BEGIN SELECT [Id], [DefaultValue] FROM [dbo].[ChannelSettings] where (SettingName = @SettingName) AND (SettingName <>'StreamOutTMATSIntervalMs' AND SettingName <>'BridgeType' AND SettingName <> 'CanIsFD' AND SettingName <> 'CanArbBaseBitrate' AND SettingName <> 'CanArbBaseSJW' AND SettingName <> 'CanDataBitrate' AND SettingName <> 'CanDataSJW' AND SettingName <> 'CanFileType') END ELSE BEGIN SELECT [SettingName] FROM [dbo].[ChannelSettings] where (Id = @Id) AND (SettingName <>'StreamOutTMATSIntervalMs' AND SettingName <>'BridgeType' AND SettingName <> 'CanIsFD' AND SettingName <> 'CanArbBaseBitrate' AND SettingName <> 'CanArbBaseSJW' AND SettingName <> 'CanDataBitrate' AND SettingName <> 'CanDataSJW' AND SettingName <> 'CanFileType') END END ELSE BEGIN SELECT [Id], [SettingName], [DefaultValue] FROM [dbo].[ChannelSettings] WHERE (SettingName <>'StreamOutTMATSIntervalMs' AND SettingName <>'BridgeType' AND SettingName <> 'CanIsFD' AND SettingName <> 'CanArbBaseBitrate' AND SettingName <> 'CanArbBaseSJW' AND SettingName <> 'CanDataBitrate' AND SettingName <> 'CanDataSJW' AND SettingName <> 'CanFileType') END END