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 2 years, 11 months ago by  bent.