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'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.63 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)  = 441 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.625 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)  = 290 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 269 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 449 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 479 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 690 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 959 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -37.5 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)  = 1249 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 244 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 245 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 510 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 558 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 561 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 573 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 586 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 594 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 614 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 662 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 884 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 975 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1005 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1052 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1054 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1071 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1072 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1095 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1103 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1118 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1158 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1170 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36.75 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)  = 1301 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 209 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 844 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 992 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 995 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1108 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1127 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1146 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1148 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1149 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1150 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1157 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1198 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1200 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1217 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1221 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1244 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1263 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1264 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1284 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1324 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1325 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1334 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1341 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1342 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1343 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1355 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1356 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1361 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1362 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -36 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)  = 1366 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25.08 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)  = 349 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25.08 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)  = 711 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 199 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 212 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 494 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 534 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 539 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -25 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)  = 574 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 63 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 115 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 187 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 198 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 335 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 342 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 432 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 478 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 537 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 540 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 571 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 764 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 800 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 812 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 879 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 897 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 898 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 904 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 932 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 948 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 990 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 1009 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24.5 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)  = 1296 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 70 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 411 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 465 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 782 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 790 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 805 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 807 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 823 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 874 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 881 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 949 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 963 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1038 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1047 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1077 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1078 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1091 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1096 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1117 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1122 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1152 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1159 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1202 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1262 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1270 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1273 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1281 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1322 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1326 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1327 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -24 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)  = 1347 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -18 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)  = 890 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 3 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 13 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 52 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 57 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 62 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 104 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 253 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 261 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 1042 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 1101 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 1105 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 1241 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -16 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)  = 1367 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.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)  = 4 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.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)  = 139 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 288 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 297 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 498 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 872 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 935 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.5 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)  = 953 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 12 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 205 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 369 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 393 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 442 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 518 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 541 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 545 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 589 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 708 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 758 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 824 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 825 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 841 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 863 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 878 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 939 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 981 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 1008 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 1028 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 1046 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 1079 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12.25 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)  = 1111 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 23 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 117 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 191 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 202 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 304 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 433 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 452 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 547 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 569 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 810 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 858 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 873 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 880 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 885 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 944 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 993 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1000 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1013 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1014 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1030 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1032 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1058 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1062 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1063 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1064 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1069 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1073 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1107 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1128 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1130 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1137 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1154 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1220 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1222 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1240 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1254 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1255 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1256 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1258 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1259 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1278 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1280 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1285 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1286 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1335 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1336 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1339 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1345 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1351 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1352 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -12 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)  = 1359 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -6 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)  = 278 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -6 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)  = 700 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = -6 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)  = 1164 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 455 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 477 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 504 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 522 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 556 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 584 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 680 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 682 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 688 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 691 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 703 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 831 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 835 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 901 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 902 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 907 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 962 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 966 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 989 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1003 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1022 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1025 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1026 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1039 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1044 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1050 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1051 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1076 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1094 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1102 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1125 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1139 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1140 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1143 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1160 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1165 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1173 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1176 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1195 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1203 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1269 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1274 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1276 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1292 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1297 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1332 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1333 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1337 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1354 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1357 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1358 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
UPDATE DB_OSP_YEARLY_BREAKDOWN SET Brought_Forward_Amount = 0 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)  = 1364 AND '1 Jan 2022' BETWEEN l.Start_Date AND ISNULL(l.End_Date, '31 dec 2499'))
