Results 1 to 4 of 4

Thread: PIVOT key

  1. #1
    Join Date
    Aug 2009
    Posts
    37

    Unanswered: PIVOT key

    Hi
    how to use 'PIVOT' key in sql

    can any one explain how to use it with example

    Thanks
    Rami Reddy.B

  2. #2
    Join Date
    Aug 2009
    Posts
    37
    I did't under stand

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    There is a simple example and a complex one here:
    Using PIVOT and UNPIVOT

    I would say now I'm not a big fan of PIVOT. I think it is limited and that this is usually best done at the client.

  4. #4
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Quote Originally Posted by pootle flump View Post
    There is a simple example and a complex one here:
    Using PIVOT and UNPIVOT

    I would say now I'm not a big fan of PIVOT. I think it is limited and that this is usually best done at the client.

    And I think that may be an "understatement"!

Posting Permissions

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