sorry i forgot to update i found the solution but without logic

previous code

113 sql3="create table ##t_abc(avg decimal(5,2),year int,month int,week int)"

112 set rs=CCon.execute(sql3)

114 sql1="insert into ##t_abc select * from x...