MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
PIVOT function in sql server 2005 standard edition -

in Search

PIVOT function in sql server 2005 standard edition

Last post 06-19-2008 6:33 AM by aprato. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-19-2008 2:06 AM

    • Gundi
    • Top 500 Contributor
    • Joined on 06-19-2008
    • Posts 1

    PIVOT function in sql server 2005 standard edition

    Hi,

    How  can I make PIVOT function insql 2005 server standard edition? The function worksin enterprise edition, but standard does not seem to work.

    Regards,

    Gundi. 

      

  • 06-19-2008 6:33 AM In reply to

    • aprato
    • Top 10 Contributor
    • Joined on 12-01-2007
    • Greater Boston
    • Posts 154

    Re: PIVOT function in sql server 2005 standard edition

     It should work....how does it not work for you?   The BOL have a sample query based on AdventureWorks that you can run.

Page 1 of 1 (2 items)