- SELECT
- isnull(cast(year as varchar(25)),0) AS Year,
- isnull(cast(January as varchar(25)),0) AS January,
- isnull(cast(February as varchar(25)),0) AS February,
- isnull(cast(March as varchar(25)),0) AS March,
- isnull(cast(April as varchar(25)),0) AS April,
- isnull(cast(May as varchar(25)),0) AS May,
- isnull(cast(June as varchar(25)),0) AS June,
- isnull(cast(July as varchar(25)),0) AS July,
- isnull(cast(August as varchar(25)),0) AS August,
- isnull(cast(September as varchar(25)),0) AS September,
- isnull(cast(October as varchar(25)),0) AS October,
- isnull(cast(November as varchar(25)),0) AS November,
- isnull(cast(December as varchar(25)),0) AS December,
- isnull(January,0)+ISNULL(February,0)+ISNULL(March,0)+ISNULL(April,0)+ISNULL(May,0)+ISNULL(June,0)+ISNULL(July,0)+ISNULL(August,0)+ISNULL(September,0)+ISNULL(October,0)+ISNULL(November,0)+ISNULL(December,0) As 'Total Weight'
- FROM orderbookingdispatchmwise
- PIVOT (SUM(weight) FOR month IN ([January], [February], [March], [April], [May], [June], [July], [August], [September], [October], [November], [December])) AS PVTTable
- ORDER BY year DESC
My Output
On this Query Output All Year And Month Data Show
But I Have Show Only Current Month And year Greater Than Data
my required Output Like..
How to Possible