Got a hint and could solve it with this statement:

wth x as (select pm_extended_id, usr_kataloghierarchie from [dbo].[pm_process] where usr_kataloghierarchie is not null) update [dbo].[pm_process] set usr_kataloghierarchie =...

• This reply was modified 4 years, 4 months ago by bent.