By no means is this the only way to pivot data -- you'll find other methods in SSIS, third-party applications and even T-SQL itself. The example I show here happens to be a handy little syntax and ...