none
How to write this SQL

    Question

  • Hi All,

    I have one table, which looks like this:

    Name, WeekName, Revenue

    A, Week1,100

    A,Week2,200

    B,Week1,10

    B,Week2,10

    For Now I just want to show them like this:

    Name Week1, Week2

    A, 100, 200

    B,10,10

    How to achieve it?

    And I also want to make the week name as parameter, I mean how many week will be shown is dynamic.

    Thanks. 

    Tuesday, May 08, 2012 7:45 AM

Answers

All replies