Chris Hays's Reporting Services Sleazy Hacks We... Horizontal Tables. More with SQL Server 2005 : Top n Per Group, Pa... I previously wrote about a few of the new features in SQL 2005 and how they can be used to solve some old "classic" SQL problems very easily, and I thought I'd briefly discuss a few more.
None of this is earth-shattering stuff, but you may find seeing a bunch of these techniques listed in one place useful. All examples will be using the excellent Major League Baseball database that you can download for free here. Download the Access version, and then use the Upsizing Wizard to export the data into SQL 2005. It's a great resource and lots of fun for baseball fans; overall the design is fairly good but but not perfect (yearID ?).