IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestGraphsInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestGraphsInsert]
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_TestGraphsInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestGraphsInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestGraphsInsert]
			@TestSetupId		int			= 0
		   ,@GraphName			nvarchar(50) = null
           ,@GraphDescription	nvarchar(50)
		   ,@TestSetupName		nvarchar(50)
           ,@Channels			nvarchar(2048)
           ,@UseDomainMin		bit
           ,@DomainMin			float
           ,@UseDomainMax		bit
           ,@DomainMax			float
           ,@UseRangeMin		bit
           ,@RangeMin			float
           ,@UseRangeMax		bit
           ,@RangeMax			float
           ,@Thresholds			nvarchar(2048)
           ,@LocalOnly			bit
		   ,@errorNumber		int				output
		   ,@errorMessage		nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0);
	if(@GraphName is null)
	begin 
		RAISERROR(15600,-1,-1, 'sp_TestGraphsInsert') /* Error 1560 - An invalid parameter or option was specified for procedure*/
	end
	else
	begin
		
		if(@TestSetupId=0)
		begin
			set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)
		end

		INSERT INTO [dbo].[TestGraphs]
			([TestSetupId]
			,[GraphName]
			,[GraphDescription]
			,[Channels]
			,[UseDomainMin]
			,[DomainMin]
			,[UseDomainMax]
			,[DomainMax]
			,[UseRangeMin]
			,[RangeMin]
			,[UseRangeMax]
			,[RangeMax]
			,[Thresholds]
			,[LocalOnly])
		VALUES
			(@TestSetupId
			,@GraphName		
			,@GraphDescription	
			,@Channels			
			,@UseDomainMin		
			,@DomainMin			
			,@UseDomainMax		
			,@DomainMax			
			,@UseRangeMin		
			,@RangeMin			
			,@UseRangeMax		
			,@RangeMax			
			,@Thresholds			
			,@LocalOnly)
	end
END































GO