But in this particular case there is no correct order.

Also, I'm pretty sure that every language feature ever created has also been abused by a sufficiently uninformed developer 🙂

Thanks for the answer. It's a shame though :/

Putting a IsMaster flag in the cluster member was one of the ideas I rejected initially because it would require a procedural check which I would like to avoid. It...

I have a "Group" and a "GroupMember" table, and the rule is that a group cannot exist without a master, and a master is a member:

Group(Id, Name, MasterId)

GroupMember(GroupId, MemberId)

So Group.Master...

Ah. Of course! I was probably running the query from the master database which is picked by default by sql managment studio. Now I feel a bit silly. Thanks for...