Sql Server - PIVOT function

I've seen code in pre-Sql Server 2005 (i.e. 2000) where PIVOT-esque functions were carried out and my god were they complicated, messy, HORRID beasts. Put quite bluntly, if I never have to see that code again it'll be far too soon.

I was only reminded of this by coming across a post by Dan Wahlin titled "Pivots to the Rescue - Providing Flexible SQL Server Queries" that gives a good explanation and use-case for them. Something that I'm sure I'll find a use for in the near future!