sql运行错误,如何修改....
declare @var_now datetime
set @var_now=getdate()
declare @ee int
set @ee=(select datediff(dd,paydays,nextpaydays) from client as a left join clientpay as b on a.pkid=b.clientid and (b.paytoflag=1) where a.producttype=1)
declare @ff int
set @ff=(select datediff(dd,paydays,@var_now) from client as a left join clientpay as b on a.pkid=b.clientid and (b.paytoflag=1) where a.producttype=1 )
begin tran shiwu
if @ee> @ff
begin
select a.pkid,a.clientname,a.contractprice,a.qiantime,a.producttype,b.payid,b.paydays,b.nextpaydays,gou from client as a left join clientpay as b on a.pkid=b.clientid and (b.paytoflag=1) where a.producttype=1
end
else
if @ee< @ff
begin
select a.pkid,a.clientname,a.contractprice,a.qiantime,a.producttype,b.payid,b.paydays,b.nextpaydays,cha from client as a left join clientpay as b on a.pkid=b.clientid and (b.paytoflag=1) where a.producttype=1
end
commit tran shiwu