where ( a.fifinitial<>'1' and d.fstktype='2') and ((a.factindate>='2014-11-22' and a.factindate<'2014-11-25' )) and a.fifcancel ='0' and ( a.fifinitial<>'1' and d.fstktype='2' )
我想把这个条件改成最近三天；而不是一个具体的日期，怎么改呢？
------解决思路----------------------
DECLARE @Dt DATE=GETDATE()+1
where ( a.fifinitial<>'1' and d.fstktype='2') and ((a.factindate>=DATEADD(dd,-3,@Dt) and a.factindate<@Dt )) and a.fifcancel ='0' and ( a.fifinitial<>'1' and d.fstktype='2' )
------解决思路----------------------
where ( a.fifinitial<>'1' and d.fstktype='2') and含今天的三天的写法
((a.factindate>=CONVERT(VARCHAR(10),DATEADD(DAY,-2,GETDATE()),120)
and a.factindate<GETDATE() ))
and a.fifcancel ='0' and ( a.fifinitial<>'1' and d.fstktype='2' )