mcummings (7/31/2013)
same results, tried it
I would check the data - visually validate if returned rows are the correct ones(*) or not, if not, check what is the query returning.
(*) correct ones as defined on the actual predicate, not on the business specification.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.