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:08 am

    #1534377

    here is an example

    select CONVERT(varchar(20),dateprocessed),COUNT(*) from mydb.dbo.mytable

    where convert(date, dateprocessed)=convert(date,getdate())

    group by CONVERT(varchar(20),dateprocessed)

    order by CONVERT(datetime,CONVERT(varchar(20),dateprocessed)) desc

    MVDBA