ALTER TABLE VS4TEmpHoliday ADD
	TEhdTBracode nvarchar(30)NULL
GO
UPDATE VS4TEmpHoliday SET TEhdTBRaCode=(SELECT tbracode FROM vs4tbranch WHERE tbraTBRTALIAS = 'HEADOFFICE')
GO
ALTER TABLE VS4TEmpHoliday ALTER COLUMN
	TEhdTBracode nvarchar(30) NOT NULL
GO
ALTER TABLE VS4TEmpHoliday
	DROP CONSTRAINT IF EXISTS TEhdHolidayDate
GO
ALTER TABLE VS4TEmpHoliday ADD CONSTRAINT
	TEhdHolidayDate PRIMARY KEY CLUSTERED 
	(
	TEhdTBracode,
	TEhdHolidayDate
	) ON [PRIMARY]
GO
