SQL Server offers a utility called OLAP (Online Analytical Processing) that far surpasses the functionality of Pivot Tables and Cross Tab Queries. It comes with SQL Server it just needs to be installed. There are wizards included to help you through the process. If you are dead set on doing a Cross Tab I'd suggest use a reporting utility such as Crystal Reports or MS Access.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.