- select ITEM_DEPTS,SUM(item_RESIDUE) item_sum,SUM(item_RESIDUE*item_price) item_total,item_time,DOMAINID,FORMID from CQMDB.dbo.tlk_t_resourceReserveDetails where convert(varchar(100),ITEM_TIME,23)=convert(varchar(100),GETDATE(),23) and parent in (select id from CQMDB.dbo.tlk_t_resourceReserve) and ITEM_RESIDUE>0 group by ITEM_DEPTS,DOMAINID,FORMID,item_time having SUM(item_RESIDUE)>0
复制代码 |