各位老师,周末安好!我现有一程式如下面所示,因为不知如何写所以只能用最笨的方法处理日期,倚望有老师指点.能用新的代码替换.
数据表的结构:
product lotno mpsdate qty
pb1 2810 2008-12-1 100
pb2 2811 2008-12-2 100
pb3 2812 2008-12-1 100
... ... ...select product,lotno,[2008-12-1],[2008-12-02],...[2008-12-31] from (select * from dialy ) a
pivot (max(totalqty) for mpsdate in ([2008-12-1],[2008-12-02]],...[2008-12-31] )) b
order by product
-----------------------------------------
希望转换后的表结构:
product lotno 2008-12-1 2008-12-2 2008-12-3 2008-12-4 ..........2008-12-31
pb1 2810 100
pb2 2811 100
pb3 2812 100
数据表的结构:
product lotno mpsdate qty
pb1 2810 2008-12-1 100
pb2 2811 2008-12-2 100
pb3 2812 2008-12-1 100
... ... ...select product,lotno,[2008-12-1],[2008-12-02],...[2008-12-31] from (select * from dialy ) a
pivot (max(totalqty) for mpsdate in ([2008-12-1],[2008-12-02]],...[2008-12-31] )) b
order by product
-----------------------------------------
希望转换后的表结构:
product lotno 2008-12-1 2008-12-2 2008-12-3 2008-12-4 ..........2008-12-31
pb1 2810 100
pb2 2811 100
pb3 2812 100
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货