How can i create crosstab quaries on SQL server . I know how to do it in a MDB database.
If anyone can help.Probably one of the most common questions. Unfortunately, there's no simple answer that comes straight from the box (at least, not using T-SQL).
You can do several things:
1. Create a very cumbersome SELECT statement using CASE statements.
2. Use MS Access as your front-end with linked tables to your SQL Server
3. Buy one of a couple of 3rd party tools:
www.rac4sql.com
www.ag-software.com
Regards,
hmscott|||Try this link mate:
http://www.winnetmag.com/SQLServer/Article/ArticleID/15608/15608.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment