DECLARE @i TINYINT = 2
    , @param NVARCHAR(32) = N'@int TINYINT'
    , @sql NVARCHAR(MAX) = '
        UPDATE dwh.sap.AccountingDocumentSegment
        SET ExtraBudgetaryHolderId = 0
        WHERE ExtraBudgetaryHolderId IS NULL
            AND $partition.fn_partition_year(FiscalYear) = @int;
        '
WHILE 1 = 1
BEGIN
    BEGIN TRY
        EXECUTE sp_executesql @sql, @param, @int = @i;
        SET @i += 1;
    END TRY
    BEGIN CATCH
        THROW
        RETURN;
    END CATCH
END;