|
jafrywilson
Constraint Violating Yak Guru
India
379 Posts |
 Posted - 02/05/2013 : 08:36:59
|
Hi all,
This query gives me the result, but i need to convert the rows into column based on PayMode
SELECT Utility.UtilityValue as PayMode,sum(isnull(CLPH.AmountPaid,0)) AS AmountPaid
FROM ClassPayment_History as CLPH
Left join Utility on Utility.UID = CLPH.Paymode
GROUP BY UtilityValue
This is a dynamic column, so i couldn't able to specify column names in pivot query. |
|
Pivot for dynamic table
