PIVOT TABLE EXAMPLE
CREATE TABLE #TempPrasad
(
Val int,
Dt DATETIME
)
INSERT INTO #TempPrasad VALUES(2,'1/1/2013')
INSERT INTO #TempPrasad VALUES(1,'1/1/2013')
INSERT INTO #TempPrasad VALUES(2,'1/1/2013')
INSERT INTO #TempPrasad VALUES(1,'2/1/2013')
INSERT INTO #TempPrasad VALUES(2,'3/1/2013')
INSERT INTO #TempPrasad VALUES(4,'3/1/2014')
SELECT *
FROM (
SELECT
left(datename(month,dt),3)as [month],
Val
FROM #TempPrasad
) as s
PIVOT
(
SUM(Val)
FOR [month] IN (jan, feb, mar, apr,
may, jun, jul, aug, sep, oct, nov, dec)
)AS pivott
DROP TABLE #TempPrasad
Directly runt the above Above script in ssms,it could give you the solution.