表newgudong中有字段“nmd”,需要从表ggjc中获取相同股票代码的年加仓次数的统计次数,并把统计次数插入到表newgudong中的字段“nmd”,且能批量完成计算,请教下面的写法哪里出错了,或者劳烦老师您帮写一个,谢谢!:
<%
Dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.Execute("insert into newgudong.nmd values(select count(*) as total from ggjc where newgudong.stockid=ggjc.stockid and datediff('d',bddate,now())<=365)")
set conn=nothing
%>