>>>>Kevin, it works like a charm, wonderful, thank you very much. Please let me know where you have your blog.
>>>
>>>In the meantime you can check my articles on PIVOT:
>>>
>>>http://social.technet.microsoft.com/wiki/contents/articles/17510.t-sql-dynamic-pivot-on-multiple-columns.aspx
>>>
>>>http://social.technet.microsoft.com/wiki/contents/articles/17351.sql-server-pivot.aspx
>>
>>
>>Do you have any shame? Kevin worked with John and solved his problem. You pop in with an egregious display of egotism by displaying links to your articles.Who cares what you write. Kevin is a national level author, trainer and recognized expert in sql server. When you have written more books than he has, that will give you the right to jump in and try to minimize his prowess at your expense.
>
>I had no problems solving that problem as well if I would see it (I don't work on Saturday thus I didn't see it) and the articles I show are good, so I have no problems suggesting them.

As usual, totally oblivious, to anything or anyone else other than you.