I could use some help figuring out the sql for a problem. Currently, there are 2 tables: Domain, which has columns domainID, and parentDomainID. ParentDomainID references another Domain record. EndUser, which has a column parentDomainID.
I have a procedure where I am looping over domainIDs (variable @currentDomainID). I need to do now is update all EndUser records that are in the currentDomainID or where the any parent of the endUser parentDomainID is the @parentDomainID.