Matt Marston (5/13/2008)
The PIVOT statement can be useful at times, but it is handy to know that anything that can be done with a PIVOT statement can be converted to an equivalent query without the PIVOT statement.
For those that don't know about Matt's fine example, it's called a "Cross Tab" query and examples can be found in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.