摘要：
1. 創(chuàng)建臨時(shí)表CREATE TABLE #TmpTable(RYear INT,--年份RMonth INT,--月份RQty INT--數(shù)據(jù))2. 數(shù)據(jù)如下INSERT INTO #TmpTable( RYear, RMonth, RQty) SELECT T.RYear,T.RMonth,T.RQty FROM (SELECT 2011 RYear,1 RMonth,100 RQty UNION ALL SELECT 2011 RYear,1 RMonth,100 RQty UNION ALL SELECT 2011 RYear,2 RMonth,50 RQty UNION ALL SE 閱讀全文
posted @ 2011-09-28 14:43
踏歌長(zhǎng)行
閱讀(1196)
評(píng)論(0)
推薦(0)
摘要：
1. 創(chuàng)建臨時(shí)表CREATE TABLE #TmpTable(RYear INT,--年份JQty INT,--一月的數(shù)據(jù)FQty INT,--二月的數(shù)據(jù)MQty INT,--三月的數(shù)據(jù)AQty INT--四月的數(shù)據(jù))2. 數(shù)據(jù)如下INSERT INTO #TmpTable( RYear, JQty, FQty, MQty, AQty )SELECT T.RYear,T.JQty,T.FQty,T.MQty,T.AQty FROM (SELECT 2011 RYear,1 JQty,2 FQty,3 MQty,4 AQty UNION ALLSELECT 2011 RYear,1 JQty,2 閱讀全文
posted @ 2011-09-28 13:26
踏歌長(zhǎng)行
閱讀(223)
評(píng)論(0)
推薦(0)
浙公網(wǎng)安備 33010602011771號(hào)