Hafez Rabbani (ha**********@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,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp