📄 ins_cxtj_dm.sql
字号:
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''03''
','','01','','04','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','5','0','select 5 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''04''
','','01','','05','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','6','0','select 6 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''05''
','','01','','06','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','7','0','select 7 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''06''
','','01','','07','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','8','0','select 8 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''07''
','','01','','08','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','9','0','select 9 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
from v_a2_1
where 1=1 and dwxz = ''08''
','','01','','09','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','10','0','select 10 xh,count(distinct(dwid)) col1,count(distinct(decode(aj_flag,''04'',dwid))) col2,count(distinct(decode(fkje,null,null,dwid))) col3
,sum(decode(fkje,null,0,fkje)) col4,sum(qtwlrs) col5,'''' col6
from v_a2_1
where 1=1
','','01','','10','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','0','12','select 12 xh ,count(distinct(dwid)) row1,count(distinct(decode(dwxz,''01'',dwid))) row2
,count(distinct(decode(dwxz,''02'',dwid))) row3,count(distinct(decode(dwxz,''03'',dwid))) row4
,count(distinct(decode(dwxz,''04'',dwid))) row5,count(distinct(decode(dwxz,''05'',dwid))) row6
,count(distinct(decode(dwxz,''06'',dwid))) row7,count(distinct(decode(dwxz,''07'',dwid))) row8
,count(distinct(decode(dwxz,''08'',dwid))) row9
from v_a2_2
where 1=1 and sfhg = ''02''
','','01','','11','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('','a2','0','8','','','06','(0,5)/(0,4)','12','2');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a3','1','0','select 1 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
from v_a3
where 1=1
','','01','','01','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a3','3','0','select 3 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
from v_a3
where 1=1 and dwxz = ''02''
','','01','','03','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a3','5','0','select 5 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
from v_a3
where 1=1 and dwxz = ''04''
','','01','','05','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a3','6','0','select 6 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
from v_a3
where 1=1 and dwxz = ''05''
','','01','','06','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a3','8','0','select 8 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
from v_a3
where 1=1 and dwxz = ''07''
','','01','','08','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('qx','a4','1','0','select 1 xh,sum(decode(ssbz,''01'',1,0)) col4,sum(decode(ssbz,''02'',1,0)) col5
,sum(1) col6,sum(decode(zjlb,''01'',1,0)) col7,sum(decode(zjlb,''02'',1,0)) col8
,'''' col9,'''' col10
from v_a4_1
where 1=1','','01','','01','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('qx','a4','2','0','select 2 xh,sum(decode(ssbz,''01'',1,0)) col4,sum(decode(ssbz,''02'',1,0)) col5
,sum(1) col6,sum(decode(zjlb,''01'',1,0)) col7,sum(decode(zjlb,''02'',1,0)) col8
,'''' col9,'''' col10
from v_a4_1
where 1=1 and qx = ''001''
','','01','','02','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('qx','a4','3','0','select 3 xh,sum(decode(ssbz,''01'',1,0)) col4,sum(decode(ssbz,''02'',1,0)) col5
,sum(1) col6,sum(decode(zjlb,''01'',1,0)) col7,sum(decode(zjlb,''02'',1,0)) col8
,'''' col9,'''' col10
from v_a4_1
where 1=1 and qx <> ''001'' and sfjd = ''02''
','','01','','03','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('qx','a4','4','0','select 4 xh,sum(decode(ssbz,''01'',1,0)) col4,sum(decode(ssbz,''02'',1,0)) col5
,sum(1) col6,sum(decode(zjlb,''01'',1,0)) col7,sum(decode(zjlb,''02'',1,0)) col8
,'''' col9,'''' col10
from v_a4_1
where 1=1 and qx <> ''001'' and sfjd = ''01''
','','01','','04','0');
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a4','0','6','select 9 xh,sum(1) row1,sum(decode(pxbm,''001'',1,''321'',1,0)) row2
,sum(decode(pxbm,''001'',0,''321'',0,1)) row3,sum(decode(pxbm,''001'',0,''321'',0,1)) row4
from v_a4_2
where 1=1
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -