http://blog.alecl.com/archive/2007/06/18/creative-queries.aspxTwo interesting techniques I came upon: http://www.sqlteam.com/article/sql-sever-2005-using-over-with-aggregate-functions Retrieve aggregate data using OVER(Partition by ...) rather than doing another join http://weblogs.sqlteam.com/jeffs/archive/2007/06/12/60230.aspxenCommunityServer 2.1 SP2 (Build: 61129.2)