Home Forums SQL Server 2008 T-SQL (SS2K8) Help with query using exclusion table RE: Help with query using exclusion table

  • March 20, 2013 at 7:45 am

    #1598900

    Got it... Added:

    AND bh.Server NOT IN

    (SELECTrel.Server

    FROMReportExclusionList rel

    WHEREbh.Server = rel.Server

    ANDbh.database_name = rel.DatabaseName)

    AND bh.database_name NOT IN

    (SELECTrel.Server

    FROMReportExclusionList rel

    WHEREbh.Server = rel.Server

    ANDbh.database_name = rel.DatabaseName)

    Works as expected now...