DP44/DataPRO_sql/dbo.sp_TestSetupObjectsGet.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestSetupObjectsGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestSetupObjectsGet]
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_TestSetupObjectsGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestSetupObjectsGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestSetupObjectsGet]
			 @TestObjectName	nvarchar(255) = null
AS
BEGIN
	
	SELECT tobj.[TestObjectName]
		  ,ts.[TestSetupName]
		  ,tso.[TargetSampleRate]
		  ,tso.[ExcitationWarmupTimeMS]
		  ,tso.[LocalOnly]
		  ,tso.[TestObjectType]
		  ,tso.[TestObjectPosition]
	FROM [dbo].[TestSetupObjects] tso 
	inner join [dbo].[TestSetups] ts on ts.TestSetupId = tso.TestSetupId
	inner join [dbo].[TestObjects] tobj on tobj.TestObjectId = tso.TestObjectId
	WHERE @TestObjectName is null or tobj.TestObjectName = @TestObjectName
	
END	






























GO