Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    144

    Question Unanswered: How can I retrieve a recordset from a matrix-like table?

    I have a table defined as (int Row, int Column, money Data); as it were a matrix.

    Which is the more efficient way of retrieving a result set with the following form?

    Column1 Column2 Column3
    ---------- ----------- ----------
    Data11 Data12 Data13
    Data21 Data22 Data23
    Data31 Data32 Data33
    ... ... ...


    Thanks a lot in advance.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Lookup "Crosstab queries" in Books Online, and you will see a perfect example of how to do what you want to do.
    If it's not practically useful, then it's practically useless.

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

Posting Permissions

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