IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEFineLocations1Insert]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEFineLocations1Insert]
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_MMEFineLocations1Insert]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEFineLocations1Insert] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEFineLocations1Insert]
			 @s_GUID			uniqueidentifier = null
			,@FINE_LOC_1		nvarchar(50)
			,@TEXT_L1			nvarchar(50)
			,@TEXT_L2			nvarchar(50)
			,@VERSION			int
			,@DATE				datetime
			,@REMARKS			nvarchar(50)
			,@EXPIRED			bit
			,@SORTKEY			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)

	SET NOCOUNT ON;
	INSERT INTO [dbo].[MMEFineLocations1]
           ([s_GUID]
           ,[FINE_LOC_1]
           ,[TEXT_L1]
           ,[TEXT_L2]
           ,[VERSION]
           ,[DATE]
           ,[REMARKS]
           ,[EXPIRED]
           ,[SORTKEY]
           ,[LAST_CHANGE]
           ,[LAST_CHANGE_TEXT]
           ,[HISTORY])
     VALUES
           (@s_GUID				
           ,@FINE_LOC_1			
           ,@TEXT_L1			
           ,@TEXT_L2			
           ,@VERSION			
           ,@DATE				
           ,@REMARKS			
           ,@EXPIRED			
           ,@SORTKEY			
           ,@LAST_CHANGE		
           ,@LAST_CHANGE_TEXT	
           ,@HISTORY)

	set @new_id = scope_identity();

END






























GO