9 lines
382 B
Plaintext
9 lines
382 B
Plaintext
|
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
|