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

USE [C6]GO/****** 对象:  StoredProcedure [dbo].[Pro_SelectMoneyInfo_New]    脚本日期: 04/13/2012 12:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[Pro_SelectMoneyInfo_New] @comp varchar(1000)asbeginif exists(select  sum(paymoney) as totaljefrom Form_FRCW_PayApply b inner join JHOA_Approve con b.ID=c.AppO_Values and c.App_Over=1  andc.App_IdeaFlag=9 and c.Del_flag=0Group 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 totaljefrom Form_FRCW_PayApply b inner join JHOA_Approve con b.ID=c.AppO_Values and c.App_Over=1  andc.App_IdeaFlag=9 and c.Del_flag=0Group 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)endelsebeginselect 0 as totaljeendend/*select * from  Form_FRCW_PayApply b inner join JHOA_Approve con b.ID=c.AppO_Values and c.App_Over=1  andc.App_IdeaFlag=9 and c.Del_flag=0and year(getdate())=year(c.App_EndTime) and month(getdate())=month(c.App_EndTime)and appo_title like '%百度%'*/--exec Pro_SelectMoneyInfo_New '申请百度推广续费10000元'