50分送给解决一个简单的存储过程的英雄

[msnadair]

我下面的存储过程编译时报如下错误：
Server Message: Number 137, Severity 15
Server 'linux', Procedure 'insertdata', Line 12:
Must declare variable '@i'.

往各位大侠帮我修改一下，让它能正常跑起来。此存储过程的目的是：从表ADDRESS_GROUP取数据（NAME，GROUPID）插入到company表中。company表中有一自增索引列companyid，不允许重复。




create procedure insertdata
as
declare
@id numeric
@i numeric
@len numeric
begin
select @i =1
select @len =select count(1) from gdtest.dbo.ADDRESS_GROUP
while @i <=@len
insert into company(companyid,companyname,company_query_type,authflag,auth_by_ldap,remark1) select @id,NAME,1,0,0,GROUPID from ADDRESS_GROUP
select @i =@i +1
end
end

[hobbylu]

create procedure insertdata
as
declare
@id numeric
declare @i numeric
declare @len numeric
begin
select @i =1
select @len =select count(1) from gdtest.dbo.ADDRESS_GROUP
while @i <=@len
insert into company(companyid,companyname,company_query_type,authflag,auth_by_ldap,remark1) select @id,NAME,1,0,0,GROUPID from ADDRESS_GROUP
select @i =@i +1
end
end

[天鹅要蛤蟆吃]

我想那样写会出问题啊，可以用游标试一试。每一次循环插入一条，直到@i =@i + 1 = @len结束。

[Tigersong]

declare @id numeric ,
@i numeric ,
@len numeric

[msnadair]

那个存储过程是错误的