求1.03需改动一些地方！长城、扎营、渡口样子

じ☆vの龍

k看看长点见识！

他们都叫我残缺

回复看看。。。

sgb6700tt

ddddddddddddddddddddddddd

就在这一天

支持楼主

qq954320854

.........................

blsmsxp

kankan~~~~~~~~~

ベ现实︷

DDDDDDDDDDDDDDD

xu420830881

楼主好人一生平安

bbxz

{:soso_e103:}.............

重拾信念者

外交官可以做斥候~

stock

kankanbucuo

kelvinleung2010

不要要挺久的

2276960970

select YYYY,RETROFIT_TYPE,SELL_01 as SELL_WITHIN_01,SELL_02 as SELL_WITHIN_02,SELL_03 as SELL_WITHIN_03,SELL_04 as SELL_WITHIN_04,SELL_05 as SELL_WITHIN_05,SELL_06 as SELL_WITHIN_06,SELL_07 as SELL_WITHIN_07,SELL_08 as SELL_WITHIN_08,SELL_09 as SELL_WITHIN_09,SELL_10 as SELL_WITHIN_10,SELL_11 as SELL_WITHIN_11,SELL_12 as SELL_WITHIN_12,AMOUNT as AMOUNTT_WITHIN from  (select YYYY,RETROFIT_TYPE,0 as sort, sum(SELL_WITHIN_01) as SELL_01,sum(SELL_WITHIN_02) as SELL_02, sum(SELL_WITHIN_03) as SELL_03,sum(SELL_WITHIN_04) as SELL_04, sum(SELL_WITHIN_05) as SELL_05,sum(SELL_WITHIN_06) as SELL_06, sum(SELL_WITHIN_07) as SELL_07,sum(SELL_WITHIN_08) as SELL_08, sum(SELL_WITHIN_09) as SELL_09,sum(SELL_WITHIN_10) as SELL_10, sum(SELL_WITHIN_11) as SELL_11,sum(SELL_WITHIN_12) as SELL_12, sum(ifnull(SELL_WITHIN_01,0)+ifnull(SELL_WITHIN_02,0)+ifnull(SELL_WITHIN_03,0)+ ifnull(SELL_WITHIN_04,0)+ifnull(SELL_WITHIN_05,0)+ifnull(SELL_WITHIN_06,0)+ifnull(SELL_WITHIN_07,0)+ ifnull(SELL_WITHIN_08,0)+ifnull(SELL_WITHIN_09,0)+ifnull(SELL_WITHIN_10,0)+ifnull(SELL_WITHIN_11,0)+ ifnull(SELL_WITHIN_12,0)) as AMOUNT from scm_rpt_o_0270_vw  Group by YYYY,RETROFIT_TYPE  union select YYYY,RETROFIT_TYPE,1 as sort, sum(SELL_BEYOND_01) as SELL_01,sum(SELL_BEYOND_02) as SELL_02, sum(SELL_BEYOND_03) as SELL_03,sum(SELL_BEYOND_04) as SELL_04, sum(SELL_BEYOND_05) as SELL_05,sum(SELL_BEYOND_06) as SELL_06, sum(SELL_BEYOND_07) as SELL_07,sum(SELL_BEYOND_08) as SELL_08, sum(SELL_BEYOND_09) as SELL_09,sum(SELL_BEYOND_10) as SELL_10, sum(SELL_BEYOND_11) as SELL_11,sum(SELL_BEYOND_12) as SELL_12, ifnull(sum(ifnull(SELL_BEYOND_01,0)+ifnull(SELL_BEYOND_02,0)+ifnull(SELL_BEYOND_03,0)+ ifnull(SELL_BEYOND_04,0)+ifnull(SELL_BEYOND_05,0)+ifnull(SELL_BEYOND_06,0)+ ifnull(SELL_BEYOND_07,0)+ifnull(SELL_BEYOND_08,0)+ifnull(SELL_BEYOND_09,0)+ ifnull(SELL_BEYOND_10,0)+ifnull(SELL_BEYOND_11,0)+ifnull(SELL_BEYOND_12,0)),0) as AMOUNT  from scm_rpt_o_0270_vw  Group by YYYY,RETROFIT_TYPE union select YYYY,RETROFIT_TYPE,2 as sort,round(100* sum(SELL_WITHIN_01)/(sum(SELL_WITHIN_01)+ifnull(sum(SELL_BEYOND_01),0)),2) as SELL_01,round(100* sum(SELL_WITHIN_02)/(sum(SELL_WITHIN_02)+ifnull(sum(SELL_BEYOND_02),0)),2) as SELL_02,round(100* sum(SELL_WITHIN_03)/(sum(SELL_WITHIN_03)+ifnull(sum(SELL_BEYOND_03),0)),2) as SELL_03,round(100* sum(SELL_WITHIN_04)/(sum(SELL_WITHIN_04)+ifnull(sum(SELL_BEYOND_04),0)),2) as SELL_04,round(100* sum(SELL_WITHIN_05)/(sum(SELL_WITHIN_05)+ifnull(sum(SELL_BEYOND_05),0)),2) as SELL_05,round(100* sum(SELL_WITHIN_06)/(sum(SELL_WITHIN_06)+ifnull(sum(SELL_BEYOND_06),0)),2) as SELL_06,round(100* sum(SELL_WITHIN_07)/(sum(SELL_WITHIN_07)+ifnull(sum(SELL_BEYOND_07),0)),2) as SELL_07,round(100* sum(SELL_WITHIN_08)/(sum(SELL_WITHIN_08)+ifnull(sum(SELL_BEYOND_08),0)),2) as SELL_08,round(100* sum(SELL_WITHIN_09)/(sum(SELL_WITHIN_09)+ifnull(sum(SELL_BEYOND_09),0)),2) as SELL_09,round(100* sum(SELL_WITHIN_10)/(sum(SELL_WITHIN_10)+ifnull(sum(SELL_BEYOND_10),0)),2) as SELL_10,round(100* sum(SELL_WITHIN_11)/(sum(SELL_WITHIN_11)+ifnull(sum(SELL_BEYOND_11),0)),2) as SELL_11,round(100* sum(SELL_WITHIN_12)/(sum(SELL_WITHIN_12)+ifnull(sum(SELL_BEYOND_12),0)),2) as SELL_12,round(100*  sum(ifnull(SELL_WITHIN_01,0)+ifnull(SELL_WITHIN_02,0)+ifnull(SELL_WITHIN_03,0)+ ifnull(SELL_WITHIN_04,0)+ifnull(SELL_WITHIN_05,0)+ifnull(SELL_WITHIN_06,0)+ ifnull(SELL_WITHIN_07,0)+ifnull(SELL_WITHIN_08,0)+ifnull(SELL_WITHIN_09,0)+ ifnull(SELL_WITHIN_10,0)+ifnull(SELL_WITHIN_11,0)+ ifnull(SELL_WITHIN_12,0))/ (ifnull(sum(ifnull(SELL_BEYOND_01,0)+ifnull(SELL_BEYOND_02,0)+ifnull(SELL_BEYOND_03,0)+ ifnull(SELL_BEYOND_04,0)+ifnull(SELL_BEYOND_05,0)+ifnull(SELL_BEYOND_06,0)+ ifnull(SELL_BEYOND_07,0)+ifnull(SELL_BEYOND_08,0)+ifnull(SELL_BEYOND_09,0)+ ifnull(SELL_BEYOND_10,0)+ifnull(SELL_BEYOND_11,0)+ifnull(SELL_BEYOND_12,0)),0)+  sum(ifnull(SELL_WITHIN_01,0)+ifnull(SELL_WITHIN_02,0)+ifnull(SELL_WITHIN_03,0)+ ifnull(SELL_WITHIN_04,0)+ifnull(SELL_WITHIN_05,0)+ifnull(SELL_WITHIN_06,0)+ ifnull(SELL_WITHIN_07,0)+ifnull(SELL_WITHIN_08,0)+ifnull(SELL_WITHIN_09,0)+ ifnull(SELL_WITHIN_10,0)+ifnull(SELL_WITHIN_11,0)+ ifnull(SELL_WITHIN_12,0))),2) as AMOUNT from scm_rpt_o_0270_vw Group by YYYY,RETROFIT_TYPE) T where  1=1 AND YYYY = '2013'  order by YYYY,RETROFIT_TYPE,sort limit 0,10000

wang649755396

自导自演

gtsoho

期待汉之殇的完善 不要要挺久的

563201431

路过看啊可能

chaos-1987

瞅瞅！！
http://www.1mod.org/forum.php?mo ... p;extra=#pid2504899

绕地飞行

{:5_113:}{:5_113:}

西伯^利亚狼

很好！很强大！

fthmo1983

路过打酱油{:5_144:}