declare cursor_for_num_set_fr cursor for
   select num_set_fr from #temp_num_set_fr order by num_set_fr

open cursor_for_num_set_fr

fetch cursor_for_num_set_fr into @num_set_fr

select @num_set_fr_old= 0 
while @@sqlstatus= 0 
begin
   if @num_set_fr <> @num_set_fr_old
   begin

      declare cursor_for_emp cursor for
         select s.amount_in_car,m.drawing
         from dbo.xxoi_msk_set s, dbo.xxoi_msk m 
         where s.num_set=@num_set_fr and m.id=s.id_msk and m.type_msk='up'

      open cursor_for_emp

      fetch cursor_for_emp into @count_emp, @emp

      if @@sqlstatus= 0 
      begin
         update #temp_num_set_fr
         set emp_1=@emp, count_emp1=@count_emp
         where #temp_num_set_fr.num_set_fr=@num_set_fr
         fetch cursor_for_emp into @count_emp, @emp         
      end
      if @@sqlstatus= 0 
      begin
         update #temp_num_set_fr
         set emp_2=@emp, count_emp2=@count_emp
         where #temp_num_set_fr.num_set_fr=@num_set_fr
         fetch cursor_for_emp into @count_emp, @emp                  
      end
      if @@sqlstatus= 0 
      begin
         update #temp_num_set_fr
         set emp_3=@emp, count_emp3=@count_emp
         where #temp_num_set_fr.num_set_fr=@num_set_fr
      end
      close cursor_for_emp
      select @num_set_fr_old=@num_set_fr
   end

   fetch cursor_for_num_set_fr into @num_set_fr
end

close cursor_for_num_set_fr