Transpose rows to columns

  • Hi All,

    I have a result set like say a client with more than one inservice date.

    And i am grouping those inservices for a particular client.

    say i get some 4 or 5 inservice date for it.

    i have some  10 columns in my group head and in detail i want to display this inservice date not in rows to be transposed to columns and if this inservice exceeds the 10 columns it should move to next row

    is that possible?

    sample:

    clientname  cert 1        date 1        cert 2       date 2      cert 3         date 3

    __________________________________________________________________

    Abey          1               1/2/2005     2            1/3/2005    3          1/5/2005  inserdate1 

    inserdate2 

    inserdate3 

    inserdate4

    inserdate5

    inserdate6

    inserdate7

    inserdate8 

    inserdate9

    __________________________________________________________________

    Aboaf         1               1/2/2005     2            1/3/2005    3          1/5/2005  inserdate1 inserdate2 inserdate3 inserdate4  inserdate5  inserdate6 inserdate7

    __________________________________________________________________

    and i should get like this

    clientname  cert 1        date 1        cert 2       date 2      cert 3         date 3

    Abey          1               1/2/2005     2            1/3/2005    3          1/5/2005  inserdate1 inserdate2 inserdate3 inserdate4  inserdate5  inserdate6 inserdate7

    inserdate8  inserdate9

    __________________________________________________________________

    Aboaf         1               1/2/2005     2            1/3/2005    3          1/5/2005  inserdate1 inserdate2 inserdate3 inserdate4  inserdate5  inserdate6 inserdate7

     

    please help me!

    Regards

    Priya

  • Without more detail on your reordset, If your using SQL 2005 then look into the PIVOT function.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

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

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