>>Who cares... Links to others works don't make you a superstar. Try doing some original stuff on your own... maybe then I'll buy into your sense of worth, but not till then..
>>
>>Show me 100 posts you have made pointing to your ORIGINAL work and I'll become a believer. I bet you can't show me 5...
>
>Why don't you do your homework yourself?
>
>I only show a few, because I don't normally save them and google is not too helpful. I searched on just the 'PIVOT' topic.
>
>http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9e15d459-cc74-481e-aa0e-4eebfe91cb41/how-to-pivot-on-two-or-more-columns-for-a-same-column-values
>
>http://social.msdn.microsoft.com/Forums/sqlserver/en-US/96a63133-ddef-4a12-8fb2-7b6015f10d05/pivot-with-unknown-number-of-column-in-sql
>
>http://social.msdn.microsoft.com/Forums/en-US/5c4ba997-9e80-42fc-b81f-b0093dd944af/sql-pivot-query
>
>http://social.msdn.microsoft.com/Forums/en-US/d8b4358b-d8ba-4a10-b519-ae9893b70c36/help-with-query-kind-of-pivot-but-not-really


LOL.. Like I said, you couldn't show me 5, you showed me 4..