Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    9

    Unanswered: Help with Cross-tab queries

    How would you write the SQL statement to do a cross-tab queries.

    My Table
    DCNID-unique ID
    AuditID-FK to the main table
    DCN-int
    Error Type (combo box with values tooth, date, provider, etc)
    Line ID (combo box with values 1-40)
    Adjustment Code-text

    I would like my report to look like this.
    DCN
    LineID Tooth Date Provider
    1 1 1
    2 1
    3
    4
    5
    ..
    40

    Thank you so much!

    Cristy

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You could have done some research, this question has been asked and aswered thousands of times, here are some solutions from asktom:

    http://asktom.oracle.com/pls/ask/f?p...:7086279412131,
    http://asktom.oracle.com/pls/ask/f?p...A:419593546543,
    http://asktom.oracle.com/pls/ask/f?p...A:766825833740,
    http://asktom.oracle.com/pls/ask/f?p...A:925229353765,



    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by cristy
    How would you write the SQL statement to do a cross-tab queries.
    that depends -- what database system are you using?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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