none
working to format the data like Matrix RRS feed

  • Question

  • Hi Experts,

    I've data in table in the format...

      
    Card Number             MonthYear       CC              Limit   balance   D     B       Bbb
    --------------------------------------------------------------------------------------------------
    456356923595985958 January 2009 1234567890 7000 220   NULL 0 NULL


    like this we have data from Jan 2009 to dec 2011, now we want to display data as below

    Card Number             January 2009                                                         February 2009
    ----------------------------------------------------------------------------------------------------------------------------------------------
    456356923595985958  CC                 Limit   balance   D     B       Bbb     CC                      Limit     balance   D     B       Bbb 

                                        1234567890 7000    220        NULL 0     NULL      6589359595212 4322   212        NULL 0     NULL

    Could you please help in writing query in sql server.
    Is it possible?

    Thanks in advance
    --NoorBi

    Thursday, August 22, 2013 10:59 AM

Answers

All replies