UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -54 WHERE Plan_Type = 'Holiday' AND Year = 2022 AND Master_Id =
(SELECT TOP 1 l.Right_Join FROM LNK_EMPLOYEE_CONTRACT l INNER JOIN DT_EMPLOYEE e ON e.Entity_Id = l.Left_Join AND CAST(e.EmployeeID as int)  = 553 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
