下面语句哪里错了??declare @fname datetime
set @fname = getdate()select daima,mingcheng,sum(zhengfu) from meirishuju
where daima in (select daima from daima where biaoji=2)
and date in (DateAdd(day,-1,'@fname'),
DateAdd(day,-2,'@fname'),
DateAdd(day,-3,'@fname'),
DateAdd(day,-4,'@fname'),
DateAdd(day,0,'@fname'))
group by daima,mingcheng
order by sum(zhengfu) desc
set @fname = getdate()select daima,mingcheng,sum(zhengfu) from meirishuju
where daima in (select daima from daima where biaoji=2)
and date in (DateAdd(day,-1,'@fname'),
DateAdd(day,-2,'@fname'),
DateAdd(day,-3,'@fname'),
DateAdd(day,-4,'@fname'),
DateAdd(day,0,'@fname'))
group by daima,mingcheng
order by sum(zhengfu) desc
set @fname = getdate() select daima,mingcheng,sum(zhengfu) from meirishuju
where daima in (select daima from daima where biaoji=2)
and [date] in (DateAdd(day,-1,@fname),
DateAdd(day,-2,@fname),
DateAdd(day,-3,@fname),
DateAdd(day,-4,@fname),
DateAdd(day,0,@fname))
group by daima,mingcheng
order by sum(zhengfu) desc
declare @fname datetime
set @fname = getdate()
select daima,mingcheng,sum(zhengfu) from meirishuju
where daima in (select daima from daima where biaoji=2)
and date in (DateAdd(day,-1,@fname),
DateAdd(day,-2,@fname),
DateAdd(day,-3,@fname),
DateAdd(day,-4,@fname),
DateAdd(day,0,@fname))
group by daima,mingcheng
order by sum(zhengfu) desc
set @fname = getdate() select daima,mingcheng,sum(zhengfu) from meirishuju
where daima in (select daima from daima where biaoji=2)
and date in (DateAdd(day,-1,@fname),
DateAdd(day,-2,@fname),
DateAdd(day,-3,@fname),
DateAdd(day,-4,@fname),
DateAdd(day,0,@fname))
group by daima,mingcheng
order by sum(zhengfu) desc