摘要: 需求 : 行列转换实现SQL : SELECT*FROM(SELECTItem,Grp='Overoll',Num=[Overoll]FROM#testUNIONALLSELECTItem,Grp='I_Branch',Num=[I_Branch]FROM#testUNIONALLSELECTItem,Grp='P_Branch',Num=[P_Branch]FROM#testUNIONALLSELECTItem,Grp='CNG',Num=[CNG]FROM#testUNIONALLSELECTItem,Grp='Tra 阅读全文
posted @ 2012-04-07 10:42 IT-民工 阅读(251) 评论(0) 推荐(0)