Hey
try this not exact but close to your answer work little on it u will get your answer
WITH tempWith AS
(SELECT TMonth,TYear,
CASE TYear
WHEN '2011' THEN Revenue END AS [2011Revenue],
CASE TYear
WHEN '2011' THEN Tax end as [2011Tax] ,
CASE TYear
WHEN '2012' THEN Revenue END AS [2012Revenue],
CASE TYear
WHEN '2012' THEN Tax END AS [2012Tax]
FROM dbo.TaxDetail)
SELECT TMonth, MAX([2011Revenue]) AS [2011 Revenue],
MAX([2011Tax])AS [2011 Tax],
MAX([2012Revenue]) AS [2012 Revenue],
MAX([2011Tax])AS [2012 Tax]
FROM tempWith
GROUP BY TMonth