摘要:SELECT Q1.ProductName,(Q2.M1 & Power(2,OrderDate)) * SaleVolume AS M1,(Q2.M2 & Power(2,OrderDate)) * SaleVolume AS M2,(Q2.M3 & Power(2,OrderDate)) * SaleVolume AS M3,(Q2.M4 & Power(2,OrderDate)) * SaleVolume AS M4,(Q2.M5 & Power(2,OrderDate)) * SaleVolume AS M5,(Q2.M6 & Power
阅读全文
posted @ 2011-03-17 20:11