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.
In pseudocode what I need to do is this:
Any help would be appreciated.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads