From: Erland Sommarskog on 3 Aug 2010 03:23 Eric Isaacs (eisaacs(a)gmail.com) writes: >> FROM � weeks >> GROUP �BY weeks > > I would expect you would want to GROUP BY AnglerId instead of Weeks. Me too! :-) Thanks! -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
First
|
Prev
|
Pages: 1 2 Prev: SSRS Report - when rows expanded they jump under fixed column head Next: Count over group |