摘要:
答案:SELECTSalesPersonID,[1]ASJAN,[2]ASFEB,[3]ASMAR,[4]ASAPRFROM(SELECTSalesPersonID,DATEPART(MM,OrderDate)ASMONFROMSales.SalesOrderHeaderWHEREDATEPART(yyyy,OrderDate)=2002)SPIVOT(COUNT(MON)FORMONIN([1]... 阅读全文
posted @ 2009-12-23 16:28
Gsun
阅读(401)
评论(0)
推荐(0)

浙公网安备 33010602011771号