CrossTab

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

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