set rs1=server.createobject("adodb.recordset")
set rs2=server.createobject("adodb.recordset")
sql = "SELECT mc,sl FROM a"
rs1.open sql,conn,3,3
rs2.open sql,conn,3,3
a = 0
b = " "
while rs1.eof
name = rs1("MC")
sum=0
a = rs("MC")&','
if instr(a,b) = 0 then
while rs2.eof
if name = rs2("MC") then
sum = sum + rs2("sl")
end if
wend
rs2.movefirst
response.write name
response.write " "
response.write sum
response.write "<br>"
b = b&a
end if
wend
输出第一个表时根据名称排一下序,然后一条记录一条记录查,如果字段名与前一个名称不同的话就显示其名称,且输出和,然后和又初始为零,如果字段名与前一个名称相同数就加,
代码如下:
dim suma
dim Name
suma=0
name=""
while not rs.eof
if rs("mc")<>name then
if name="" then '是第一条
name=rs("mc")
suma=suma+rs("sltotal")
else
response.write name
response.write suma
name=rs("mc")
suma=rs("sltotal")
end if
else
suma=suma+rs("sltotal")
end if
rs.movenext
wend
response.write name
response.write suma
sql="SELECT mc, Sum(sl) AS sltotal FROM a GROUP BY mc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do until rs.eof
response.write "<tr><td>"&rs("mc")&"</td><td>"&rs("sltotal")&"</td></tr>"
rs.movenext
loop
rs.close