Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    5

    Unanswered: Dynamic pivot in view

    I have to transpose column in view

    For me column is not Known previously so I cant hard code column in pivot are any existing method of transpose
    If i use dynamic pivot . I am not able to use dynamic pivot in view
    So i need solution to transpose column dynamically in view
    With out hard coding column in query
    i have data like this
    ----------------------------------------------------
    Slip Modified Date
    A 2010-03-12
    B 2010-03-11
    F 2010-03-13
    H 2010-03-14
    ----------------------------
    i want out as follow

    2010-03-12 2010-03-11 2010-03-13 2010-03-14
    A B F H
    -------------------------------------------------

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is a presentation level issue, not a data transformation. A well designed system will handle this in the Application or the Presentation layer, not in the database.

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

  3. #3
    Join Date
    Aug 2006
    Posts
    3

    This is true, PatP, only in theory....

    ... and the theory limited by one's experience.

    In practice, there are many cases when on DB level one would benefit from dynamic pivot remaining in a good design.

    If anyone knows an answer to the original question, it would be very much appreciated.

    Thanks,

    Igor

Posting Permissions

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