日期:2014-05-18 浏览次数:20687 次
select sum(jqquantity-sjqquantity-yjqquantity),sum(jqcost-sjqcost-HDBJE),sum(jqquantity-sjqquantity),sum(jqcost-sjqcost),sum((jqquantity-jqquantity)-(sjqquantity-jqquantity)),sum(HRK) as HRK,sum(HRKJE) as HRKJE,sum(HGYLRK) as HGYLRK,sum(HGYLRKJE) as HGYLRKJE,sum(HFLRK) as HFLRK, sum(HFLRKJE) as HFLRKJE,sum(HYCRK) as HYCRK,sum(HYCRKJE) as HYCRKJE,sum(HCK) as HCK,sum(HCKJE) as HCKJE,sum(HGYLCK) as HGYLCK,sum(HGYLCKJE) as HGYLCKJE, sum(HFLCK) as HFLCK,sum(HFLCKJE) as HFLCKJE,sum(HDB) as HDB,sum(HDBJE) as HDBJE,sum(HYCCK) as HYCCK,sum(HYCCKJE) as HYCCKJE, sum(WRK) as WRK,sum(WRKJE) as WRKJE,sum(WGYLRK) as WGYLRK,sum(WGYLRKJE) as WGYLRKJE,sum(WFLRK) as WFLRK,sum(WFLRKJE) as WFLRKJE,sum(WYCRK) as WYCRK, sum(WYCRKJE) as WYCRKJE,sum(WCK) as WCK,sum(WCKJE) as WCKJE,sum(WGYLCK) as WGYLCK,sum(WGYLCKJE) as WGYLCKJE,sum(WFLCK) as WFLCK,sum(WFLCKJE) as WFLCKJE, sum(WDB) as WDB,sum(WDBJE) as WDBJE,sum(WYCCK) as WYCCK,sum(WYCCKJE) as WYCCKJE from @t