DP44/DataPRO_sql/dbo.sp_LevelTriggersGet.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_LevelTriggersGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_LevelTriggersGet]
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_LevelTriggersGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_LevelTriggersGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_LevelTriggersGet]
		@TestSetupName			nvarchar(255)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT  
	 ts.TestSetupName
	,tobj.TestObjectName
	,tobj.TestObjectName + '_' + convert(varchar(1), lt.MMEChannel)  + '_' + convert(varchar(5), lt.MMEChannelId)	as 'TestObjectChannelId'
	,d.SerialNumber + '_' + convert(varchar(3), d.[Type]) + 'x' + convert(varchar(5), lt.HardwareChannelId)			as 'HardwareChannelId'
	,sn.SerialNumber as SensorSerialNumber
	,lt.[GreaterThanEnabled]
	,lt.[GreaterThanEU]
	,lt.[LessThanEnabled]
	,lt.[LessThanEU]
	,lt.[InsideUpperEU]
	,lt.[InsideLowerEU]
	,lt.[OutsideUpperEU]
	,lt.[OutsideLowerEU]
	,lt.[TriggerInside]
	,lt.[TriggerOutside]
	FROM [dbo].[LevelTriggers] lt 
		inner join [dbo].[TestSetups] ts on ts.TestSetupId = lt.TestSetupId 
		inner join [dbo].[TestObjects] tobj  on tobj.TestObjectId = lt.TestObjectId
		inner join [dbo].[DAS] d on d.DASId = lt.DASId
		inner join [dbo].[v_SensorSerialNumber] sn on sn.SensorId = lt.SensorId
	WHERE @TestSetupName is null or ts.TestSetupName = @TestSetupName 	

END
































GO