我的两重游标查询为什么查4分钟还在查询中？

Question

说明： 　　1，入库表：Seekin_next 　　2，出库表：Seekout_next 目的：显示各个仓库（storeid）每种产品（prdtid）的需求数量（pcount）和实际数量（amount） 语句如下： SELECT top 10 [storeid]      ,[pcount]      ,[amount]      ,[prdtid] into Seekin_next  FROM Seekin go SELECT top 10 [storeid]      ,[pcount]      ,[amount]      ,[prdtid] into Seekout_next  FROM Seekout goIf   Object_Id( 'Tempdb.dbo.#Sresult')   Is   Not   NULL--#Test 为临时表名   begin  Print 'Exists Table'  drop table #Sresult  endElse begin  Print 'Not Exists Table'create table #Sresult( [prdtid] [char](7) NOT NULL, [storeid] [nvarchar](20) NOT NULL, [pcount] [float] NULL, [amount] [money] NULL,)end declare @prdtid1 char(7),@storeid1 nvarchar(20),@pcount1 float,@amount1 moneydeclare @prdtid2 char(7),@storeid2 nvarchar(20),@pcount2 float,@amount2 moneydeclare @pcount_result float,@amount_result money declare cursor1 cursor for select * from Seekin_nextfor read onlyopen cursor1fetch next from cursor1into @prdtid1,@storeid1,@pcount1,@amount1while @@FETCH_STATUS=0begin --内层循环开始 set @pcount_result=0 set @amount_result=0 declare cursor2 cursor for  select * from Seekout_next for read only open cursor2 fetch next from cursor2 into @prdtid2,@storeid2,@pcount2,@amount2 while @@FETCH_STATUS=0 begin  if @prdtid1=@prdtid2 and @storeid1=@storeid2  begin   set @pcount_result=(@pcount1-@pcount2)+@pcount_result   set @amount_result=(@amount1-@amount2)+@pcount_result  end end insert into #Sresult (prdtid,storeid,pcount,amount) values (@prdtid1,@storeid1,@pcount_result,@amount_result) close cursor2 deallocate cursor2 --内层循环结束 endclose cursor1deallocate cursor1select * from #Sresultgo 结果：等了4分钟还需要等待查询，为什么啊？救命啊！