Home Forums SQLServerCentral.com Anything that is NOT about SQL! 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.

  • September 6, 2012 at 5:31 am

    #1534396

    ok - so change your grouping and, order by and select to use

    DATEPART(hh,mydatecolumn)

    i'm sure you can then figure out how to display the date in the query

    MVDBA