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...
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...