Here's just a couple of queries I often use when report writing and I need to "find" the data. These queries were courtesy of much time on stack overflow a few years back. These have since received a couple of tweaks and stay in my query