Home Forums SQL Server 2005 T-SQL (SS2K5) Each GROUP BY expression must contain at least one column that is not an outer reference. RE: Each GROUP BY expression must contain at least one column that is not an outer reference.

  • November 10, 2008 at 5:10 am

    #896216

    Remove 'Category' from your GROUP BY clause

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537