如何获得订单
问题描述：
在下面的数据透视表中，我无法按日期获得订单。请帮助我。如何获得订单
例如： - 十一月，十二月，一月
select *
from
(
select
Dsgn_Entered_By,
COUNT(ddif_number) DDIF_Number,
SUBSTRING(DATENAME(MONTH,Entered_Date),0,10) as Date,
DATEPART(mm,Entered_Date) Entered_Date
from Design_Entry_Fixture_Input
group by Entered_Date,Dsgn_Entered_By
)
yy
PIVOT
(
SUM(DDIF_Number)
for Dsgn_Entered_By IN ([chandru.r],[praveen.n],[CHETAN B],[HANUMANTH REDDY],[PRAVEEN NAIK],[saravana.k],[Yogitha])
)PVT
order by Entered_Date
答
试试这个：
select *
from
(
select *
from
(
select
Dsgn_Entered_By,
COUNT(ddif_number) DDIF_Number,
SUBSTRING(DATENAME(MONTH,Entered_Date),0,10) as Date,
DATEPART(mm,Entered_Date) Entered_Date
from Design_Entry_Fixture_Input
group by Entered_Date,Dsgn_Entered_By
)
yy
PIVOT
(
SUM(DDIF_Number)
for Dsgn_Entered_By IN ([chandru.r],[praveen.n],[CHETAN B],[HANUMANTH REDDY],[PRAVEEN NAIK],[saravana.k],[Yogitha])
)PVT) t
order by Entered_Date
[这个线程（http://stackoverflow.com/questions/13755017/how-to-order -by-in-sql-pivot）可能会帮助你 –
你大概会收到一条错误消息。如果您将错误的确切文本添加到您的问题中，这将非常有用。 –