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
