单位:万元,保留两位小数
以下为进度表语句 (此表为加快生成速度,项目列文字需对照“征收项目”代码先手工填入)
--SP_JDB_JKDZ_JNBY今年本月入库
SELECT ZSXM_DM,
round(SUM(SE)/10000,2)
FROM V_KJ_SB_ZSXX_RKRQ
WHERE RKRQ>= $$0011 AND (RKRQ< $$0012 OR RKRQ=$$0012)
and ZSXM_DM=&&c888999000000002
and substr(nsr_swjg_dm,1,7)=1431123
group by ZSXM_DM
--SP_JDB_JKDZ_JNLJ今年累计入库
SELECT ZSXM_DM,
round(SUM(SE)/10000,2)
FROM V_KJ_SB_ZSXX_RKRQ
WHERE RKRQ>= $$0010 AND (RKRQ< $$0012 OR RKRQ=$$0012)
and ZSXM_DM=&&c888999000000002
and substr(nsr_swjg_dm,1,7)=1431123
group by ZSXM_DM
--SP_JDB_JKDZ_QNTY去年同月入库
SELECT ZSXM_DM,
round(SUM(SE)/10000,2)
FROM V_KJ_SB_ZSXX_RKRQ
WHERE RKRQ>=add_months( $$0011,-12) AND (RKRQ
and ZSXM_DM=&&c888999000000002
and substr(nsr_swjg_dm, 1, 7)=1431123
group by ZSXM_DM
--SP_JDB_JKDZ_QNLJ去年累计入库
SELECT ZSXM_DM,
round(SUM(SE)/10000,2)
FROM V_KJ_SB_ZSXX_RKRQ
WHERE RKRQ>=add_months( $$0010,-12) AND (RKRQ
and ZSXM_DM=&&c888999000000002
and substr(nsr_swjg_dm, 1, 7)=1431123
group by ZSXM_DM