Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Rome
    Posts
    12

    Question Unanswered: Crosstab query...?

    Hi,
    with MS Access I can create a crosstab query with this function:

    TRANSFORM <aggfunction>
    SelectStatement
    PIVOT <pivotfield>

    ...but on Sybase? Can you help me?

    THANK YOU.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Not so easy.
    you have 2 methods : both are time consuming :-(

    1) create a temporary table with all your columns and populate it using insert/updates
    2) use a temporary table including a lot of 0, and 1 in the diagonal (like a matrix) and make a multiplication with a this inversed matrix

Posting Permissions

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