This week's book giveaway is in the OCAJP forum. We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line! See this thread for details.
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.