Home Forums SQL Server 2008 SQL Server 2008 - General Check that a specific Group By condition does not exist RE: Check that a specific Group By condition does not exist

  • September 7, 2012 at 10:16 am

    #1535155

    sku370870 (9/7/2012)

    Thanks for your reply ... it's giving me the opposite of what I want because I phrased my question back to front.

    What I need is:

    Join to the temporary table but only if every group within the temporary table has a BaseStage of 1.

    i.e. make it so that if there is a group without a BaseStage of 1 - it returns nothing - no join happens.

    Not sure what you are asking. You only provided one table in your initial post. Also, if I read this correction correctly, based on the data provided in the initial post, you want nothing back as none of the groups have a BaseStage = 1 for all rows in a group.