Microsoft SQL Server forum

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

CrossTab

Hafez Rabbani

2005-08-23, 3:23 am

Hi Guys!
Is there anything like cross tab of access in sql server?
Thanks.

Erland Sommarskog

2005-08-23, 3:23 am

Hafez Rabbani (hafezrabbani@gmail.com) writes:
> Hi Guys!
> Is there anything like cross tab of access in sql server?

You can do cross-tabs in SQL Server, but it it is not as straightforward
as it is in Access.

There is a section in Books Online that gives some tips about this:
Accessing and Changing Relational Data / Transact-SQL Tips / Cross-Tab
Reports

That section covers static crosstabs. Dynamic crosstabs requires use of
dynamic SQL and requires more work. There is a third-party product, RAC,
which is popular for this, check out http://www.rac4sql.net/.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Sponsored Links