IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEDirectionsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEDirectionsUpdate]
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_MMEDirectionsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEDirectionsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEDirectionsUpdate]
            @s_GUID				uniqueidentifier
           ,@DIRECTION			nvarchar(50)
           ,@TEXT_L1			nvarchar(255)
           ,@TEXT_L2			nvarchar(255)
           ,@DATE				datetime
           ,@VERSION			int
           ,@EXPIRED			bit
           ,@REMARKS			nvarchar(max)
           ,@LAST_CHANGE		datetime
           ,@LAST_CHANGE_TEXT	nvarchar(255)
           ,@HISTORY			nvarchar(max)
           ,@SORTKEY			nvarchar(50)
			,@errorNumber		int				output
			,@errorMessage		nvarchar(250)	output 
AS
BEGIN
	set @errorNumber = 0 
	set @errorMessage = space(0)

	SET NOCOUNT ON;
	UPDATE [dbo].[MMEDirections]
		   SET [DIRECTION]						= @DIRECTION			
			  ,[TEXT_L1]						= @TEXT_L1			
			  ,[TEXT_L2]						= @TEXT_L2			
			  ,[DATE]							= @DATE				
			  ,[VERSION]						= @VERSION			
			  ,[EXPIRED]						= @EXPIRED			
			  ,[REMARKS]						= @REMARKS			
			  ,[LAST_CHANGE]					= @LAST_CHANGE		
			  ,[LAST_CHANGE_TEXT]				= @LAST_CHANGE_TEXT	
			  ,[HISTORY]						= @HISTORY			
			  ,[SORTKEY]						= @SORTKEY			
		 WHERE [s_GUID]							= @s_GUID
END






























GO