Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    11

    Unanswered: Crosstab Quaries on SQL server

    How can i create crosstab quaries on SQL server . I know how to do it in a MDB database.
    If anyone can help.
    Pankaj Garg

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    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

  3. #3
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Talking


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •