SQL Server pivot query

I blogged about Pivot query, sometimes referred to as a cross-tab query, a while ago.
Mike has mentioned pivot syntax in SQL Server here. I checked it out.
I wouldn’t describe it as cool or glamorous, but it is a neat feature that I hope Oracle will adopt. I know, not easy, for some pride issues.

Advertisements

4 Responses to “SQL Server pivot query”

  1. Maximus Says:

    I would like to see a continuation of the topic

  2. Dong Says:

    Maximus,

    Oracle has come out with its version of the pivot syntax in 11g.
    Check out this one:
    http://www.pythian.com/blogs/612/oracle-11g-new-pivot-table-feature

    DJ

  3. Przemysław Michalski Says:

    its quite usefull technique of matrix transformation – I thing it could be fast in computing transformation data (f.ex.) – but does anybody know how it works with huge (2-3GB) data tables with simple columns structure ?

  4. Dong Says:

    Przemysław,

    I would imagine it depends on the number and size of columns involved in the matrix transformation. Also, given the 2-3GB, I would probably opt for more traditional OLAP technologies. Cognos(IBM), Oracle, SQLServer all have OLAP that build the cubes for faster data analysis.

    DJ

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: