Post reply

Using pivot in SQL 2000?

  • March 16, 2011 at 6:50 am

    #248434

    Our company have SQL 2008 and 2000 servers.

    Is it possible of using pivot statement in SQL 2008 query (from management studio) and read data in SQL 2000 (using linked server)?

  • March 16, 2011 at 6:57 am

    #1299324

    Yes, it is possible, though it could end up performing badly. What have you tried so far?

    If you need help you can come back to this thread and ask a specific question.

    -- Gianluca Sartori

  • March 16, 2011 at 7:05 am

    #1299328

    I need create a crosstab store procedure using pivot statement but SQL 2000 do not support pivot.

  • March 16, 2011 at 7:08 am

    #1299330

    You can create cross tabs even without PIVOT operator: check out this great article from Jeff Moden:

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    -- Gianluca Sartori

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply