• lanky_doodle - Wednesday, February 28, 2018 10:13 AM

    But when grouping is true, the Everyone select is still there, because I am using literal values.

    The SELECT clause is evaluated AFTER the WHERE clause, so using literal values in the SELECT clause cannot possibly have any effect on the number of records returned.  Specifically, it cannot cause records to return in place of an empty set.  You need to look elsewhere to determine why those values are showing up in your results.  I would start by running each of your UNIONed sets separately.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA