Files
DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/05/056713b495e7816a35c2b7b56d71292f26b217a7.svn-base

21 lines
1.3 KiB
Plaintext
Raw Permalink Normal View History

2026-04-17 14:55:32 -04:00
<EFBFBD><EFBFBD>ALTER PROCEDURE [dbo].[sp_DASChannelsGet]
@HardwareId nvarchar(50) = null
AS
BEGIN
SET NOCOUNT ON;
SELECT d.[SerialNumber] + '_' + convert(varchar(2), d.[Type]) as HardwareId
,dc.[DASId]
,dc.[ChannelIdx]
,dc.[SupportedBridges]
,dc.[SupportedExcitations]
,dc.[DASDisplayOrder]
,dc.[LocalOnly]
,dc.[SupportedDigitalInputModes]
,dc.[SupportedSquibFireModes]
,dc.[SupportedDigitalOutputModes]
,dc.[ModuleSerialNumber]
,dc.[ModuleArrayIndex]
from [dbo].[DASChannels] dc inner join [dbo].[DAS] d on dc.DASId = d.DASId
where @HardwareId is null or dc.[DASId] = dbo.foo_IdGetDAS(@HardwareId)
END