Post reply

Converting Rows into Columns

  • July 26, 2010 at 4:48 pm

    #387432

    Hi

    My Data in Table is:

    CP CodeStartDateTotal Pageviews

    510142010-06-2713939018

    510142010-07-0414412508

    510142010-07-1114976381

    530372010-06-2732939

    530372010-07-0420307

    530372010-07-1123942

    How can I get it like this:

    CP Code2010-06-272010-07-04 2010-07-11

    51014 13939018 14412508 14976381

    53037 32939 20307 23942

    Converted Date into Columns

    Can u give me SQL query to do this?

    Thanks

  • July 26, 2010 at 4:59 pm

    #1198494

    Please have a look at the CrossTab article referenced in my signature.

    Based on that you should continue by reading the DynamicCrossTab article also referenced in my sig.

    If you need a coded example please provide ready to use sample data as described in the first link.


    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 2 posts - 1 through 1 (of 1 total)

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