可以简化以下SQL语句吗?
select [id],total=sum(totalfee),ordercount = count(billid) from v_billm
where year(datecreated)=year(@repdate)
and month(datecreated)=month(@repdate)
and day(datecreated)=day(@repdate)
and isreject=0 group by [id]
上述语句中日期型数值的比较,能否简化一下啊?
我不能直接用datecreated = @repdate
是因为datecreated中含有时分秒,而repdate只含日期.
如果只比较日期部分相等的简单SQL语句啊?
------解决方案--------------------select [id],total=sum(totalfee),ordercount = count(billid) from v_billm
where convert(char(10),datecreated,120)=convert(char(10),@repdate,120)
and isreject=0 group by [id]
------解决方案--------------------where datediff(day,datecreated,@repdate)=0 and isreject=0