那位帮忙实现存储过程？

whitecat_fah

请帮忙把以下代码通过存储过程来实现，谢谢了，
环境：windows2003 server ，程序asp 数据库sqlserver2005


<!--#include file="conn.asp"-->
<%
set rs=conn.execute("SELECT     COUNT(autoid) AS count, username FROM         user.count GROUP BY username")
while not rs.eof
if conn.execute("select count(id) as count from user.count_count where username='"&rs("username")&"'")(0)=0 then
conn.execute("insert into user.count_count(username,count,or_count) values('"&rs("username")&"','"&rs("count")&"','"&rs("count")&"')")
conn.execute("update user.user set xyb=xyb+'"&rs("count")&"' where username='"&rs("username")&"'")

else
conn.execute("update user.count_count set count='"&rs("count")&"' where username='"&rs("username")&"'")
conn.execute("update user.user set xyb=xyb+("&rs("count")&"-"&conn.execute("select or_count from user.count_count where username='"&rs("username")&"'")(0)&") where username='"&rs("username")&"'")
end if
rs.movenext
wend
%>

actionsky

http://www.google.cn/search?hl=z ... a=&aq=f&oq=

todayhero

windows+sqlserver+asp应该去windows论坛问一下