请教一个存储过程中的日期问题?

[gdivan]

各位帮帮忙!
在@sdate and @edate 设定为一个固定的日期段，假如为七天，每天结束日期多一天，那么开始日期就要减少一天，保证是七天为一个日期段，该怎么写呀？

CREATE PROCEDURE tree
@sdate
@edate
AS
select store,itemcode,sum(sp)as nsp,sum(qty)as qtyy
from spp where sldate between @sdate and @edate group by store,itemcode

[gdivan]

是不是这样:

between dateAdd(day,-7,@edate) and getdate()

[hery2002]

[Quote=引用 4 楼 gdivan 的回复:]
是不是这样:
[/Quote]

between convert(nvarchar(10),getdate()-7 ,120) and convert(nvarchar(10),getdate() ,120)

[hery2002]

CREATE PROCEDURE tree 
@sdate 
@edate 
AS 
select store,itemcode,sum(sp)as nsp,sum(qty)as qtyy 
from spp where sldate between @sdate and dateadd(day,7,@sdate) group by store,itemcode 

CREATE PROCEDURE tree 
@sdate 
@edate 
AS 
select store,itemcode,sum(sp)as nsp,sum(qty)as qtyy 
from spp where sldate between dateAdd(day,-7,@edate) and @edate group by store,itemcode 

[gdivan]

谢谢!
好像不行!
比如:
我今天的数据开始日期是20080625,结束日期就是20080701,刚好为七天,那么到七月2号的时候,开始日期应该是20080626,结束日期就是20080702,才对.
我想每天就让它这样自动循环,有没有方法可行?

[hery2002]

CREATE PROCEDURE tree 
@edate 
AS 
select store,itemcode,sum(sp)as nsp,sum(qty)as qtyy 
from spp where sldate between dateAdd(day,-7,@edate) and @edate group by store,itemcode 

把@edate赋值为getdate()...