T-SQL Tuesday # 16 : This is not the aggregate you're looking for

This week, T-SQL Tuesday is being hosted by Jes Borland (blog | twitter), and the theme is "Aggregate Functions." When people think of aggregates, they tend to think of MAX(), SUM() and COUNT(). And...