Brian, I use your sql2005 query and found out some of my sqlserver2005 were not using kerbores, I think the reason as you pointed out, is that sqlserver service is...

hi Richard,

that xml code works like a charm, thanks for sharing.

jiulu

Richard Fryar (8/19/2008)

---

In response to sunjiulu's query, you don't need a cross-tab.

A bit of magic with XML is all that's...

the pivot on aggregation function works on numbers, what I want is a pivot on literal/character. for example, instead of having sum(amount) to be pivoted, I'd like to see a...