标签： [转]SQL

.Pivot的用法体会:语句范例:select PN,[2006/5/30] as [20060530],[2006/6/2] as [20060602]from consumptiondata aPivot (sum(a.M_qty) FOR a.M_date in ([2006/5/30],[2006/6/2])) as PVT order by PNTable结构 Consumptiondata (PN,M_Date,M_qty)order by