We are building a database of Email addresses which contains several layers of groups.
Emails sent to a group are forwarded to the lower level groups and so on to the final actual recipients.
We can build a table that records this structure either with a pigs ear or with a link table (if some people are included in more than one group)
Now..... We need a query (SQL Server or Access 2003) that will allow us to report on the structure from any level. We need to be able to enter the code for a specific group any where in the heirachy of groups and then be presented with a list of all the bottom end recipients without having the intermediate levels appearing in the list.
So our issues are:
- How to write a query that drills down until it reaches the bottom without knowing how many layers it has to handle.
- How to list all of the bottom level entities without listing the intermediate levels.
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…