IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TemplateRegionsUpdate]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TemplateRegionsUpdate]
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_TemplateRegionsUpdate]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TemplateRegionsUpdate] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TemplateRegionsUpdate]
            @TemplateName		nvarchar(255)
           ,@RegionNumber		int
           ,@RegionName			nvarchar(50)
           ,@RegionDescription	nvarchar(50)
           ,@TestObject			nvarchar(50)
           ,@Position			nvarchar(50)
           ,@MainLocation		nvarchar(50)
           ,@FineLocation1		nvarchar(50)
           ,@FineLocation2		nvarchar(50)
           ,@FineLocation3		nvarchar(50)
           ,@PhysicalDimension	nvarchar(50)
           ,@Direction			nvarchar(50)
           ,@FilterClass		nvarchar(50)
           ,@LocalOnly			bit
           ,@UpperLeftX			nvarchar(50)
           ,@UpperLeftY			nvarchar(50)
           ,@LowerRightX		nvarchar(50)
           ,@LowerRightY		nvarchar(50)
           ,@ZoneName			nvarchar(50)
		   ,@errorNumber		int				output
		   ,@errorMessage		nvarchar(250)	output
AS
BEGIN
	SET NOCOUNT ON;
	declare @TemplateId int
	set @TemplateId = dbo.foo_IdGetTemplate(@TemplateName)

	UPDATE [dbo].[TemplateRegions]
		SET [RegionNumber]				= @RegionNumber		
			,[RegionName]				= @RegionName			
			,[RegionDescription]		= @RegionDescription	
			,[TestObject]				= @TestObject			
			,[Position]					= @Position			
			,[MainLocation]				= @MainLocation		
			,[FineLocation1]			= @FineLocation1		
			,[FineLocation2]			= @FineLocation2		
			,[FineLocation3]			= @FineLocation3		
			,[PhysicalDimension]		= @PhysicalDimension	
			,[Direction]				= @Direction			
			,[FilterClass]				= @FilterClass		
			,[LocalOnly]				= @LocalOnly			
			,[UpperLeftX]				= @UpperLeftX			
			,[UpperLeftY]				= @UpperLeftY			
			,[LowerRightX]				= @LowerRightX		
			,[LowerRightY]				= @LowerRightY		
			,[ZoneName]					= @ZoneName			
		WHERE [TemplateId]				= @TemplateId

END






























GO