Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2008-08-02 : 05:35:39
|
| Latest query i've as a follow result,BrdName | InvYear | InvMonth | Amount----------------------------------------------KUI | 2007 | 1 | 3800KUI | 2007 | 2 | 4300.........MUK | 2007 | 1 | 2300MUK | 2007 | 2 | 5400......JUP | 2007 | 1 | 3800......I'm stuck to make my query to arrange the result as followBrdName | Jan-2007 | Feb-2007 | Mac-2007 | ... | Dec-2007--------------------------------------------------------------KUI | 3800 | 4300 | ....MUK | 2300 | 5400 | .... | .... | ......JUP | 3800 | ..... | ...I'm really stuck till now. Help me. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-02 : 05:58:54
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107885 |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2008-08-02 : 22:58:14
|
| tq very much |
|
|
|
|
|
|
Need help in PIVOT