Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    184

    Unanswered: Pivot Tables In Sql Server???

    Hello Everybody,

    Can anyone tell me how to create a pivot table in SQL Server?

    I am attaching a picture of what the table should look like before and after the transformation. 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
    Dec 2002
    Posts
    1,245
    This is an FAQ.

    This is handled in SQL 2005, but not in 2000 or 7.0. There are a couple of 3rd-party tools that create pivot-table-like structures. Look for RAC4SQL and SQL Crosstab.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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