The primary and alternate keys really aren't a factor in this, unless I am not understanding the point. I mean, there are three ways to go: 1) update all of...

I also don't understand what you mean by "Zig-zag" or if there is an actual problem you need to solve. But I do have a couple of comments. First, unless...

Luis, I totally understood what to do and why from your excellent example. I had not remembered the whole "island" thing, frankly, but your response was incredibly instructive. I have...

Luis, thank you for your response. I really appreciate the help. And thanks for the DDL. I apologize for not formatting things properly. I guess I didn't expect anyone to...