28,391
社区成员
发帖
与我相关
我的任务
分享
<%
userid=request.form("userid")
datetime=request.form("datetime")
sqlstr = "select sum(fkje) from B where phone ='" & userid & "' and ajbh in (select ajbh from A where left(sj,patindex('%月%',sj))='" & datetime & "')"
myrs=conn.execute(sqlstr)
%>
<%
userid=request.form("userid")
datetime=request.form("datetime")
sqlstr = "select sum(fkje) from B where phone ='" & userid & "' and ajbh in (select ajbh from A where left(sj,6) = '" & datetime & "')"
myrs=conn.execute(sqlstr)
%>
<%userid=request.form("userid")
datetime=request.form("datetime")
sqlstr = "select sum(fkje) from B where phone ='" & userid & "' and ajbh in (select ajbh from A where left(sj,6) = '" & datetime & "')"
myrs=conn.execute(sqlstr)%>
select phone,sum(huafei) from B where phone in (select phone from A where datename(yyyy,sj)+ datename(mm,js)='200802') group by phone
select phone,sum(huafei) from B where phone in (select phone from A where sj='200802') group by phone