>;with cte as ( >SELECT sponsor, fundtype, amount >FROM TIP_ApprovedFunding f >INNER JOIN TIP_Projects p ON p.TipID = f.TipID >WHERE p.ApprovedStatus = 'Active' >) > SELECT * from cte > PIVOT > ( > SUM(amount) FOR FundType IN ([HSIP], [PL], [SPR], [STP], [TAP]) > ) > AS PivotTableAlias >>