Have a slew of new database tables from our master data planning source. Have in the past created new processes and tools which have revolutionized the team's auditing techniques using reports from that source, but running reports from that system is still somewhat time consuming. Now with the new tables, have been building a query to generate results for massive amounts of data, formatted in the same structure as the system reports, which will then work with existing audit tools. However the system reports perform some sort of IT magic behind the scenes to create a partially disconnected subset of the data; it's hard to explain and have had trouble figuring out how to make that magic happen in the results of my query. It's been bugging me for a couple of months. Had an epiphany yesterday while staring at the pond; the pond is where these things usually happen. Really need to come up with a good name for the pond. It's the pond of brilliant ideas. Still have some things to finish, then copy it and re-build part of it again to accommodate another configuration, then test both queries, but from the results today can clearly see it's going to work. It's going to be a great time saver for the whole team.
