存储过程

declare @a1 int
declare @char varchar(20)
declare @str nvarchar(2000)
declare cursor_name  cursor for select ss号 from aa order by ss号
open cursor_name
fetch cursor_name  into @char
while  @@fetch_status=0
begin
  set @a1=2007
  while @a1<2014
  begin
     if not exists (select 1 from r4_1 where 访问年=@a1 and 访问方式 ='DownLoad' and ss号=@char)
     begin
     set @str='insert into r4_1 values('+''''+@char+''''+','+cast(@a1 as varchar(20))+','++''''+'DownLoad'+''''+','+'0)'
     exec sp_executesql @str
     end
     if not exists (select 1 from r4_1 where 访问年=@a1 and 访问方式='Open' and ss号=@char)
       begin
     set @str='insert into r4_1 values('+''''+@char+''''+','+cast(@a1 as varchar(20))+','++''''+'Open'+''''+','+'0)'
     exec sp_executesql @str
       end
     if not exists (select 1 from r4_1 where 访问年=@a1 and 访问方式='Print' and ss号=@char)
begin
     set @str='insert into r4_1 values('+''''+@char+''''+','+cast(@a1 as varchar(20))+','++''''+'Print'+''''+','+'0)'
     exec sp_executesql @str
end
      set @a1=@a1+1
   end
 fetch cursor_name  into @char
end
close cursor_name
deallocate  cursor_name

/*
declare @a1 int
declare @char varchar(20)
declare @str varchar(200)
set @a1=2007
set  @char='11752657'
--set @str='insert into r4_1 values('+''''+@char+''''+','+cast(@a1 as varchar(20))+','''+@char+''''+','+'0)'
set @str='insert into r4_1 values('+''''+@char+''''+','+cast(@a1 as varchar(20))+','++''''+'acd'+''''+','+'0)'
select @str
*/