[p]I hope this helps[/p]

[font="Courier New"]

-- we prepare the sample data and put it in a temp table

SELECT  * INTO #sampleData

FROM

(SELECT 'AAA' AS name, 0 AS 'Jun-08' , 0 AS 'Feb-08', 200 AS 'Mar-08', 200 AS 'Total'

UNION ALL SELECT 'ABA', 200, 0, 0, 200

UNION ALL SELECT 'ABC', 100, 200, 0, 300

UNION ALL SELECT 'ACC', 0, 200, 0, 200

UNION ALL SELECT 'XXX', 0, 0, 100 ,100

UNION ALL SELECT 'XYZ', 0, 150, 100, 250)f

-- and now we simply do the rotation.

SELECT name, CONVERT(DATETIME,'1 Jun 2008',113) AS 'Month', [Jun-08] AS amount FROM #sampleData WHERE [Jun-08]>0

UNION ALL SELECT name, CONVERT(DATETIME,'Feb 2008',113), [Feb-08] FROM #sampleData WHERE [Feb-08]>0

UNION ALL SELECT name, CONVERT(DATETIME,'Mar 2008',113), [Mar-08] FROM #sampleData WHERE [Mar-08]>0

[/font]