Steve's solution looks like it will work, but I had already started testing your code with sp_MSforeachdb. I had to change it to reader was we don't have any writers....

I think your join is backwards. The initial select has blank ParentID, so the join needs to be from cte.id to DockerImage.ParentID.

JOIN    DockerImage ...

This may not be relevant, but I had a similar issue where I had an insert into a clustered columnstore, followed by an update. When the insert was small (not...

I think you need the value from the row with the min AR_LOAD_WK_DC, not the min values of the shipper code and name. If you change your code to use...