public int insertOldSbsj() {
String sql =
"select c.CODE,c.name,a.start_date,a.end_date,a.NORMAL_CNT,a.BACK_CNT,a.DEPOSE_CNT,b.machine_no,(a.NORMAL_CNT+a.BACK_CNT+a.DEPOSE_CNT) as totalSum,a.normal_sum,a.back_sum,(select count(SN) as num from SERVER_DECLARE_MAKE WHERE substring(DATETIME,0,9)>=a.start_date AND substring(DATETIME,0,9)<=a.end_date AND MACHINE_NO IN(SELECT MACHINE_NO FROM SERVER_TAXPAYER_FISCAL WHERE USER_SN IN(SELECT SN FROM SERVER_TAXPAYER_USER WHERE CODE=c.CODE))) AS YSBSUM FROM SERVER_DECLARE a left join SERVER_TAXPAYER_FISCAL b on a.FISCAL_CARD_NO=b.FISCAL_CARD_NO left outer join SERVER_TAXPAYER_USER c on b.USER_SN = c.SN WHERE a.START_DATE>='20110101' AND a.END_DATE<='20110228' group by c.CODE,a.start_date,a.end_date,c.name,a.NORMAL_CNT,a.BACK_CNT,a.DEPOSE_CNT,a.normal_sum,a.back_sum,b.machine_no";
int result = Query.executeSql(sql);
if (result == -1) {
result = 1;
} else result = -1;
return result;
}
