Post reply

RowSet Tilt Query...

  • April 12, 2011 at 10:36 pm

    #248850

    Hi Friends.. i'm looking for a query which will tilt the result row-set to columns as below.

    consider the below example..

    ------------------------------

    Student | Venkat | Hari |Priya .....

    English | 30 | 30 |30 ......

    Hindi | 30 |30 |30 ....

    Maths | 30 |30 |30...

    ------------------------------

    where in all given condition, there will be only four Rows with headings Student, English,Hindi,Maths.

    currently i'm getting as...

    -----------------------------

    Student English Hindi Maths

    Venkat 30 30 30

    Hari 30 30 30

    Priya 30 30 30

    ------------------------------

  • April 13, 2011 at 1:01 am

    This was removed by the editor as SPAM

  • April 13, 2011 at 4:47 pm

    #1311375

    You'd need to UNPIVOT your data followed by a PIVOT (either traditional using CrossTab or the PIVOT operator).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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