【三国●汉之殇】 第一回 徐州举义旗 胶东伐孔融

虫虫阿萨德

ddddddddddddddddddddd

2010lijialin

gggggggggggggggg

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

bssb12345

支持下~~~~

胡导呼呼

回复看看

destinyatsen

看下如何先

destinyatsen

{:5_126:}{:5_126:}分兵围城一定会有一个门没有守吗，还有一个骑兵进去后他们不是会回撤吗，感觉有敌人进中军帐就会夺回大营啊

LuceDelSole

谢谢分享

左手边思念_◕_

11111111111111111

甲第的淘气

看看看看看看看看看看看看看看

暮光

精彩！！

小七同学

destinyatsen 发表于 2013-4-26 00:27
分兵围城一定会有一个门没有守吗，还有一个骑兵进去后他们不是会回撤吗，感觉有敌人进中 ...

三门有一门不守，这个限于城内守军不是很多，你看我这法子打的那两架，AI都是不到半个编队；
至于中军帐被占，电脑当然会回撤，前提是他得有空闲的兵...{:soso__4607844064215092132_2:}{:soso__4607844064215092132_2:}{:soso__4607844064215092132_2:}

天涯小点

{:5_131:}{:5_138:}什么啊 。。真心无力

飘渺

看看刘备开局

义薄云

来学习啊，玩不好小刘

高際

{:soso_e100:}

583555673

看看，支持一下

LdGy

考虑们开玩笑

寒假生活

as少部分的不断放大

受伤

支持支持