C6用款中自动统计本月已付款

USE [C6]
GO
/****** 对象:  StoredProcedure [dbo].[Pro_SelectMoneyInfo_New]    脚本日期: 04/13/2012 12:15:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[Pro_SelectMoneyInfo_New] 
@comp varchar(1000)
as
begin

if exists(

select  sum(paymoney) as totalje
from Form_FRCW_PayApply b 
inner join JHOA_Approve c
on b.ID=c.AppO_Values and c.App_Over=1  and
c.App_IdeaFlag=9 and c.Del_flag=0
Group by companyname,year(c.App_EndTime),month(c.App_EndTime)
having sum(paymoney)>=0 and year(getdate())=year(c.App_EndTime) 
and  companyname=''+@comp+'' 
and month(getdate())=month(c.App_EndTime)
)

begin 
select  sum(paymoney) as totalje
from Form_FRCW_PayApply b 
inner join JHOA_Approve c
on b.ID=c.AppO_Values and c.App_Over=1  and
c.App_IdeaFlag=9 and c.Del_flag=0
Group by companyname,year(c.App_EndTime),month(c.App_EndTime)
having sum(paymoney)>=0 and year(getdate())=year(c.App_EndTime) 
and  companyname=''+@comp+'' 
and month(getdate())=month(c.App_EndTime)
end

else
begin
	select 0 as totalje
end

end
/*
select * from  Form_FRCW_PayApply b 
inner join JHOA_Approve c
on b.ID=c.AppO_Values and c.App_Over=1  and
c.App_IdeaFlag=9 and c.Del_flag=0
and year(getdate())=year(c.App_EndTime) 
and month(getdate())=month(c.App_EndTime)
and appo_title like '%百度%'
*/


--exec Pro_SelectMoneyInfo_New '申请百度推广续费10000元'