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 |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2013-02-05 : 08:36:59
|
| Hi all,This query gives me the result, but i need to convert the rows into column based on PayModeSELECT Utility.UtilityValue as PayMode,sum(isnull(CLPH.AmountPaid,0)) AS AmountPaidFROM ClassPayment_History as CLPHLeft join Utility on Utility.UID = CLPH.PaymodeGROUP BY UtilityValueThis is a dynamic column, so i couldn't able to specify column names in pivot query. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Pivot for dynamic table