﻿----------------------------AK 2022-06-08----- 
ALTER TABLE dbo.TimeAttend202201  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202201 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202202  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202202 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202203  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202203 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202204  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202204 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202205  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202205 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202206  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202206 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
----------------------------End 2022-02-01-----
----------------------------Hammad 2022-06-06-----
ALTER TABLE WF_NewJobRequest 
Alter COLUMN [Name] nvarchar(150)  not null;
Go

ALTER TABLE WF_NewJobRequest 
Alter COLUMN [Arabic_Name] nvarchar(150)  not null;
Go
----------------------------End 2022-06-06-----