循环插入的问题！

Question

begin INSERT INTO IP_Subject(stId,sName,sIndex,sState,sRevalue, sReturnState,sAddTime,sEndTime,sOPUid,sPic,sText,sNote1,sNote2) VALUES(@stId,@sName,@sIndex,@sState,@sRevalue,@sReturnState,getdate(), getdate(),@sOPUid,@sPic,@sText,@sNote1,@sNote2) DECLARE @length int --长度 DECLARE @next int --标量 DECLARE @did int --地区id DECLARE @sId1 int --获取插入的id SET @sId1=@@IDENTITY SET @next=0 SELECT @length=COUNT(*) FROM IP_CityCountry --获取长度 WHILE(@next<@length) BEGIN SELECT TOP 1 @did=ccId FROM IP_CityCountry WHERE ccId NOT IN (SELECT TOP (@next) ccId FROM IP_CityCountry) INSERT INTO IP_District_Sub_Relation(dId,sId,usrCustomID,usrState,usrRebate) VALUES(@dId,@sId1,0,0,@sRevalue) --exec MS_InsertIP_Subject 2,'修改密码',19,1,0.00,21,0,'','','','',0,0 SET @next=@next+1 END SELECT @sId1 END  这是我写的一个循环插入的存储过程。发现，执行的时候效率很慢。求高手指点，提高其效率！</p>