I did read those articles. In this case, I really dont care whether we use pivots or case statements. By reading the articles, I was able to consturct the query...