Results 1 to 3 of 3

Thread: Query Challenge

  1. #1
    Join Date
    Jan 2004
    Posts
    184

    Unanswered: Query Challenge

    Hello Everybody,

    I am attaching a picture of what the table should look like before and after the transformation. Can anybody help? Thank you in advance.
    Attached Thumbnails Attached Thumbnails pivot.jpg  
    In abundance of water only the fool is thirsty. Bob Marley.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    This is a simple CROSSTAB query. If you look up CROSSTAB in Books Online you will find an excellent explanation and example.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'll second Blindman's suggestion! Read up on the Cross-tab reports, then come back with questions.

    -PatP

Posting Permissions

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