Bookmark and Share BitCoin Donate: 13t8gAWVpHP2ddxMp88d1NFpZjnFJC6UwK

Simple unpivot example

select FeeDesc
FROM 
		(select 
		convert(varchar(255),'Annual Management Fee of 1.53% p.a. (incl. VAT).') as AnnualManagementFee,
		convert(varchar(255),'Sharing Rate of 20% for performance above benchmark.') as SharingRate,
		convert(varchar(255),'Total fee capped at 3.42% (incl. VAT)') as TotalFee)
		DERP
unpivot
(
    FeeDesc for FeeDescription in
		(AnnualManagementFee, SharingRate, TotalFee)
) as unpvt