Strong Coders Community

Where the extreme coders hang out.
Welcome to Strong Coders Community Sign in | Join | Help Messenger
in Search
Home Blogs Forums Photos Downloads
Strong Coders Community » ASP.NET / .NET Framework » AspNet2 » Equivalent SQL Code for Pivot operator(SQL Server 2005) in Sybase

Equivalent SQL Code for Pivot operator(SQL Server 2005) in Sybase

Last post 02-09-2007, 3:25 AM by manishbafna . 2 replies.
Sort Posts: Previous Next

  •  02-06-2007, 8:42 AM 1727
    • manishbafna is not online. Last active: 02-09-2007, 3:26 AM manishbafna
    • Top 10 Contributor
      Male
    • Joined on 10-18-2006
    • India
    • Posts 48
    • Points 800

    Equivalent SQL Code for Pivot operator(SQL Server 2005) in Sybase

    Hi,

    Can somebody provide me with equivalent SQL Code for Pivot operator(SQL Server 2005) in sybase?

    I have to write SQL Code in sybase in which i need to create temporary table with rows and columns swapped.

    It is really very very urgent.I would be grateful if somebody can help me out in this.

    Any help would be highly appreciated.

    Thanks and Regards,

    Manish Bafna.

    MCP and MCTS.
    • Post Points: 20
    • Alert the moderators

  •  02-08-2007, 8:27 AM 1757 in reply to 1727
    • JamesCurran is not online. Last active: Feb 10, 2007, 10:07 AM JamesCurran
    • Top 10 Contributor
      Male
    • Joined on 11-01-2006
    • Bloomfield, NJ, USA
    • Posts 82
    • Points 1,015
    • StrongCoders

    Re: Equivalent SQL Code for Pivot operator(SQL Server 2005) in Sybase

    As far as I know, there's not "one size fits all" translation, just a couple techniques to hack a particlar query.  What exactly do you want to do?
    Truth,
    James
    • Post Points: 5
    • Alert the moderators

  •  02-09-2007, 3:25 AM 1759 in reply to 1757
    • manishbafna is not online. Last active: 02-09-2007, 3:26 AM manishbafna
    • Top 10 Contributor
      Male
    • Joined on 10-18-2006
    • India
    • Posts 48
    • Points 800

    Re: Equivalent SQL Code for Pivot operator(SQL Server 2005) in Sybase

    Hi,

    I want to turn rows into columns in sybase.(similar to what pivot operator does in SQL Server 2005)

    Thanks and regards,

    Manish Bafna.
    • Post Points: 0
    • Alert the moderators

Copyright © 2006-2007 Strong Coders Community. All rights reserved. Privacy Statement | Terms Of Use
Advertise with us | Site Feedback | Chat and messenger powered by CuteSoft.NET


Powered by Community Server (Commercial Edition), by Telligent Systems