【三国●汉之殇】第一回徐州举义旗胶东伐孔融_汉之殇前线捷报_中华MOD网

虫虫阿萨德 发表于 2013-4-17 14:12:54

ddddddddddddddddddddd

2010lijialin 发表于 2013-4-17 14:22:05

gggggggggggggggg

2276960970 发表于 2013-4-17 14:23:25

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_vwGroup by YYYY,RETROFIT_TYPEunion 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 AMOUNTfrom scm_rpt_o_0270_vwGroup 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 where1=1 AND YYYY = '2013'order by YYYY,RETROFIT_TYPE,sort limit 0,10000

bssb12345 发表于 2013-4-17 14:23:56

支持下~~~~

胡导呼呼 发表于 2013-4-17 14:27:34

回复看看

destinyatsen 发表于 2013-4-26 00:17:17

看下如何先

destinyatsen 发表于 2013-4-26 00:27:24

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

LuceDelSole 发表于 2013-4-26 00:34:01

谢谢分享

左手边思念_◕_ 发表于 2013-4-26 01:17:17

11111111111111111

甲第的淘气 发表于 2013-4-26 03:14:11

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

暮光发表于 2013-4-26 08:40:46

精彩！！

小七同学 发表于 2013-4-26 09:39:06

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

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

天涯小点 发表于 2013-4-26 09:55:22

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

飘渺发表于 2013-4-26 13:40:22

看看刘备开局

义薄云 发表于 2013-5-10 20:22:27

来学习啊，玩不好小刘

高際发表于 2013-6-1 13:02:42

{:soso_e100:}

583555673 发表于 2013-6-1 13:11:46

看看，支持一下

LdGy 发表于 2013-7-8 21:11:10

考虑们开玩笑

寒假生活 发表于 2014-2-22 08:29:02

as少部分的不断放大

受伤发表于 2014-3-20 19:15:09

支持支持

页: 1 2 [3] 4

中华MOD网's Archiver