Tuesday, 6 August 2013

Order by using pivot table

Order by using pivot table

SELECT* FROM (
SELECT datename(month,[date]) as [Month],planttype,
(sum(noof50kgsbags*50))[Total Kgs] from
K_FP_Indent WHERE (date BETWEEN '2013-04-01 00:00.000' AND getdate()) AND
(attrited = 'True')
group by datename(month,[date]),month([date]), planttype,[date]
) as s
PIVOT
(
SUM([Total Kgs])
FOR [planttype] IN (A,B,C,D)
)AS s2
How to use order by statement to this query .I know that we cannot use
order by for inline queries
Output:
Month A B C D
April x X X X
August X X X X
July X X X X
Desired OP
Month A B C D
April x X X X
July X X X X
August X X X X

No comments:

Post a Comment