日期:2014-05-17 浏览次数:20691 次
select UnitEng_Name 项目名称,sum(ysje)销售,fpje 开票,sum(ysk)预收款,sj,sum(wk)尾款,fksj 付款时间
,fzr 负责人 from UDP_Contract
where fksj like '%2013-01%'
group by fksj,fpje,fksj,UnitEng_Name,fzr,sj order by fksj
-------------------------------
select UnitEng_Name 项目名称,sum(ysje)销售,fpje 开票,sum(ysk)收款,sj
,fzr 负责人 from UDP_Contract
where convert(varchar(10),fksj,120) like '%2013-01%'
group by fksj,sj,fpje,UnitEng_Name,fzr order by fksj