游标控制插入记录

游标控制插入记录
DECLARE mealcursor CURSOR FOR Select AutoID From T_MealOrderAuto
declare @count as int
declare @id as int

open mealcursor
FETCH NEXT FROM mealcursor into @id
WHILE @@FETCH_STATUS = 0
BEGIN  
 set @count = (Select Quantity From T_MealOrderAuto Where AutoID=@id)
 While(@count>0)
  begin
   if not exists (select * from t_id_count where autoid = @id and quantity=@count)
   begin
    insert into T_ID_Count (autoid,quantity) values(@id,@count)
   end
   set @count=@count-1
  end
 FETCH NEXT FROM mealcursor into @id
END
close mealcursor