Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to write Cross Tab Query in SQL Server

Status
Not open for further replies.

essa2000

Programmer
Dec 6, 2000
299
CA
Dears ;
I want to write Cross Tab Queries in SQL Server. Anyone have an idea about Pivot Tables in SQL.

Regards,
essa2000
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top