From: Erland Sommarskog on
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