idate="2006-07-15" '初始日期
iidate="2006-08-02" '结束日期
i=1
response.write "<table border=1 cellpadding=3 cellspacing=0 bordercolordark=#FFFFFF bordercolorlight=#CCCCCC><tr>"
do while datediff("d",idate,iidate)>=0
iiidate=dateadd("ww",1,idate)
i=i+1
sql="select sum(d)as xxx from aa where cast(日期字段 as smalldatetime) between '"&idate&"' and '"&iiidate&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
xx="<td width=150>第"&i&"周"&rs("xxx")&"</td>"
rs.close
response.write xx
idate=iiidate
loop
response.write "</tr></table>"
idate="2006-07-15" '初始日期
iidate="2006-08-02" '结束日期
——————————————————————————————
response.write "<table border=1 cellpadding=3 cellspacing=0 bordercolordark=#FFFFFF bordercolorlight=#CCCCCC><tr>"
——————————————————————————————
do while datediff("d",idate,iidate)>=0
iiidate=dateadd("ww",1,idate)
sql="select sum(d)as xxx from aa where cast(日期字段 as smalldatetime) between '"&idate&"' and '"&iiidate&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
——————————————————————————————
xx="<td width=150>"&rs("xxx")&"</td>"
——————————————————————————
rs.close
response.write xx
idate=iiidate
loop
________________________________________________
response.write "</tr></table>"
SELECT
DATEPART(WEEK,[时间字段]) AS '第几周',
COUNT(*) AS '数量'
FROM [数据表]
WHERE DATEPART(YEAR,[时间字段])=2005 /*这里要注意年份,避免不同年份同周的数据聚合在一起*/
GROUP BY DATEPART(WEEK,[时间字段])
ORDER BY DATEPART(WEEK,[时间字段])
select Name,intWeek,sum(Number) as QTY from (
select Name,Number,DATEPART(week,Create_Date) as intWeek from table
where date between '2006-4-3' and '2006-12-30'
) a
group by Name,intWeek
idate="2006-07-15" '初始日期
iidate="2006-08-02" '结束日期
do while datediff("d",idate,iidate)>=0
iiidate=dateadd("ww",1,idate)
sql="select sum(d)as xxx from aa where cast(日期字段 as smalldatetime) between '"&idate&"' and '"&iiidate&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
xx=rs("xxx")&"|||<br>"
rs.close
response.write xx
idate=iiidate
loop