Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2014

    Unanswered: Change display of result set from 'showing as rows, to showing as columa as one or mo

    Hi Everyone,

    I am interested in changing the way that data is displayed in my result set.

    Essentially I want to display a selection of rows (1 to n) as columns, the following diagram explains my intentions -


    Perhaps one of the greatest challenges here is the fact that I do not have a concrete number of rows (or BIN numbers).

    Each stock item could be stored in one or more BINS, which I will not know until running my query.

    Any suggestions here will be greatly appreciated.

    Kind Regards,


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    This kind of pivot transformation is best handled as close to the user as possible. Reporting packages often offer this kind of transformation as a feature.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2014
    Thanks Pat

Posting Permissions

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