Sql Pivot Query With Dynamic Columns

Possible Duplicate: T-SQL Pivot? Possibility of creating table columns from row values I've been searching in vain for too long now and have to admit defeat and ask for help, I'

Solution 1:

The best example I've seen regarding dynamic pivoting is Itzik Ben-Gan's example. This related SO Question has a pretty good example of what you would need to do. Basically, you'll need to use some dynamic sql in order to accomplish your goal.