Home Forums SQL Server 2008 SQL Server 2008 - General How to use the subquery column highglighted in the GROUP BY RE: How to use the subquery column highglighted in the GROUP BY

  • December 23, 2013 at 3:49 am

    #1675534

    Sean,

    I tried your suggestion and I have this error message. What should I do?

    Msg 144, Level 15, State 1, Procedure sp_Bank_Work_Report1, Line 18

    Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause