Link to home
Start Free TrialLog in
Avatar of ShaePNC
ShaePNC

asked on

Each GROUP BY expression must contain at least one column that is not an outer reference.

Hi,
I am getting the error message: Each GROUP BY expression must contain at least one column that is not an outer reference, when I run my query in SQL Server 2012, this query was working fine in DB2 and in looking at the other references to this error I guess I am not understanding what it is looking for.  Can some please give me some assistance?  Attached is my query:
alloc-query.txt
ASKER CERTIFIED SOLUTION
Avatar of Ioannis Paraskevopoulos
Ioannis Paraskevopoulos
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ShaePNC
ShaePNC

ASKER

I will try this and let you know.
Avatar of ShaePNC

ASKER

It worked, thanks.
Avatar of ShaePNC

ASKER

Thanks for the quick response, its nice to have other eyes that can caught simple mistakes.