DP44/DataPRO_sql/dbo.sp_MMEPossibleChannelsUpdateInsert.StoredProcedure.sql

<EFBFBD><EFBFBD>IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEPossibleChannelsUpdateInsert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEPossibleChannelsUpdateInsert]
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_MMEPossibleChannelsUpdateInsert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEPossibleChannelsUpdateInsert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEPossibleChannelsUpdateInsert]
		    @ID							bigint = 0
           ,@TYPE						nvarchar(50)
           ,@TEST_OBJECT				nvarchar(50)
           ,@POSITION					nvarchar(50)
           ,@TRANS_MAIN_LOC				nvarchar(50)
           ,@FINE_LOC_1					nvarchar(50)
           ,@FINE_LOC_2					nvarchar(50)
           ,@FINE_LOC_3					nvarchar(50)
           ,@PHYSICAL_DIMENSION			nvarchar(50)
           ,@DIRECTION					nvarchar(50)
           ,@DEFAULT_FILTER_CLASS		nvarchar(50)
           ,@TEXT_L1					nvarchar(100)
           ,@TEXT_L2					nvarchar(100)
           ,@VERSION					int
           ,@DATE						datetime
           ,@REMARKS					nvarchar(50)
           ,@EXPIRED					bit
           ,@SORTKEY					nvarchar(50)
           ,@PICTURE_SHORTNAME			nvarchar(50)
           ,@LAST_CHANGE				datetime
           ,@LAST_CHANGE_TEXT			nvarchar(50)
           ,@HISTORY					nvarchar(50)
		   ,@new_id						int OUTPUT
		   ,@errorNumber				int				output
		   ,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)
	
	if(@ID > 0 and exists(select * from [dbo].[MMEPossibleChannels] where [ID] = @ID))
	begin
		set @new_id =0
		exec dbo.sp_MMEPossibleChannelsUpdate    @ID						
												,@TYPE					
												,@TEST_OBJECT			
												,@POSITION				
												,@TRANS_MAIN_LOC			
												,@FINE_LOC_1				
												,@FINE_LOC_2				
												,@FINE_LOC_3				
												,@PHYSICAL_DIMENSION		
												,@DIRECTION				
												,@DEFAULT_FILTER_CLASS	
												,@TEXT_L1				
												,@TEXT_L2				
												,@VERSION				
												,@DATE					
												,@REMARKS				
												,@EXPIRED				
												,@SORTKEY				
												,@PICTURE_SHORTNAME		
												,@LAST_CHANGE			
												,@LAST_CHANGE_TEXT		
												,@HISTORY
												,@errorNumber output
												,@errorMessage output

	end	 	
	else
	begin
		exec dbo.sp_MMEPossibleChannelsInsert    @TYPE					
												,@TEST_OBJECT			
												,@POSITION				
												,@TRANS_MAIN_LOC			
												,@FINE_LOC_1				
												,@FINE_LOC_2				
												,@FINE_LOC_3				
												,@PHYSICAL_DIMENSION		
												,@DIRECTION				
												,@DEFAULT_FILTER_CLASS	
												,@TEXT_L1				
												,@TEXT_L2				
												,@VERSION				
												,@DATE					
												,@REMARKS				
												,@EXPIRED				
												,@SORTKEY				
												,@PICTURE_SHORTNAME		
												,@LAST_CHANGE			
												,@LAST_CHANGE_TEXT		
												,@HISTORY	
												,@new_id output	
												,@errorNumber output
												,@errorMessage output
														
	end
END











GO