set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ProcUpdateDesignation]
(
	@Name nvarchar(50),
	@AnnualLeaveMax int,
	@SickLeaveMax int,
	@EntryDate datetime,
	@UpdatedDate datetime,
	@Original_DesigIndex int,
	@Original_Name nvarchar(50),
	@Original_AnnualLeaveMax int,
	@Original_SickLeaveMax int,
	@Original_EntryDate datetime,
	@Original_UpdatedDate datetime
)
AS
SET NOCOUNT OFF;
UPDATE [tblDesignations] 
SET 
[Name] = @Name, 
[AnnualLeaveMax] = @AnnualLeaveMax, 
[SickLeaveMax] = @SickLeaveMax, 
[EntryDate] = @EntryDate, 
[UpdatedDate] = @UpdatedDate 
WHERE 
(
[DesigIndex] = @Original_DesigIndex 
AND 
[Name] = @Original_Name
AND 
[AnnualLeaveMax] = @Original_AnnualLeaveMax
AND 
[SickLeaveMax] = @Original_SickLeaveMax
AND 
[EntryDate] = @Original_EntryDate 
AND 
[UpdatedDate] = @Original_UpdatedDate
)