DP44/DataPRO_sql/dbo.sp_TestSetupDASSettingsGet.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupDASSettingsGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestSetupDASSettingsGet]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupDASSettingsGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestSetupDASSettingsGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestSetupDASSettingsGet]
		@TestSetupId	int = null,
		@TestSetupName  nvarchar(50) = null
AS
BEGIN
	SET NOCOUNT ON;
	if(@TestSetupId is null)
	begin
		set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName) 
	end

	SELECT td.[DASId]
		  ,d.SerialNumber		as DASSerialNumber
		  ,t.[TestSetupName]
		  ,td.[TargetSampleRate]
		  ,td.[ExcitationWarmupTimeMS]
		  ,td.[AAFilterRate]
		  ,td.[PreTriggerSeconds]
		  ,td.[PostTriggerSeconds]
		  ,td.[StatusLineCheck]
		  ,td.[BatteryCheck]
		  ,td.[InputVoltageMin]
		  ,td.[InputVoltageMax]
		  ,td.[BatteryVoltageMin]
		  ,td.[BatteryVoltageMax]
		  ,td.[LocalOnly]
		  
	  FROM [dbo].[TestSetupDASSettings] td
	  inner join [dbo].[TestSetups] t on t.TestSetupId = td.TestSetupId
	  inner join [dbo].[DAS] d on d.DASId = td.DASId
	  where (@TestSetupId is null or td.TestSetupId = @TestSetupId) or (@TestSetupName is null or TestSetupName = @TestSetupName)

END
































GO