declare @c varchar(17)
set @c =''
declare row_cursor cursor for select c from T
open row_cursor
fetch next from row_cursor into @c
while @@FETCH_STATUS=0
begin
exec dbo.proc_ @year,@c
fetch next from row_cursor into @c
end
close row_cursor
deallocate row_cursor
set @c =''
declare row_cursor cursor for select c from T
open row_cursor
fetch next from row_cursor into @c
while @@FETCH_STATUS=0
begin
exec dbo.proc_ @year,@c
fetch next from row_cursor into @c
end
close row_cursor
deallocate row_cursor