22 lines
654 B
Plaintext
22 lines
654 B
Plaintext
ALTER PROCEDURE [dbo].[sp_CalculatedChannelsGet]
|
|
@CalculatedChannelsId int = null
|
|
,@TestSetupName nvarchar(50) = null
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
SELECT c.[Id]
|
|
,c.[Operation]
|
|
,c.[CalculatedChannelValueCode]
|
|
,c.[InputChannelIds]
|
|
,c.[CFCForInputChannels]
|
|
,c.[CFCForOutput]
|
|
,t.[TestSetupName]
|
|
,c.[CCName]
|
|
,c.[ViewInRealtime]
|
|
,c.[ClipLength]
|
|
FROM [dbo].[CalculatedChannels] c
|
|
inner join [dbo].[TestSetups] t on t.TestSetupId = c.TestSetupId
|
|
where (@CalculatedChannelsId is null or c.Id = @CalculatedChannelsId)
|
|
AND (@TestSetupName is null or t.TestSetupName = @TestSetupName)
|
|
|
|
END |