﻿--------------------------------------- Hammad 20-02-2023 ------
ALTER TABLE dbo.TimeAttend202301  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202301 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO

ALTER TABLE dbo.TimeAttend202302  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202302 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
--------------------------------------- End 20-02-2023 ------

 --------------------------------------- mahmoud 23-02-2023 ---------
 ALTER TABLE [dbo].[Rec_JobOffer]
 ADD SerialNumber int  NULL
GO
--------------------------------------- End 23-02-2023 ---------
--------------------------------------- Hammad 23-02-2023 ---------
update RecJobOffer set RecJobOffer.SerialNumber=OfferNewSerial.RowNum
from Rec_JobOffer as RecJobOffer INNER JOIN 
(SELECT 
 ROW_NUMBER() OVER(PARTITION BY ForeignerUserCode,RecruitJobCode ORDER BY JobOfferCode) AS RowNum,
 ForeignerUserCode,
 RecruitJobCode ,JobOfferCode
FROM  Rec_JobOffer )
 as OfferNewSerial
  ON OfferNewSerial.JobOfferCode=RecJobOffer.JobOfferCode


  --------------------------------------- End 23-02-2023 ---------