---------------------------------3----------------------
				DECLARE PeopTab CURSOR FOR   
					select people.auto_card,people.pid, pc.prid
					from people
					inner join pr_current pc on pc.pid=people.pid
					inner join card on card.auto_card=people.auto_card
					inner join user_hrtb_dog_struct ds on ds.id_hr_struct=pc.Code_struct_name
					where 
					card.sex=@v_sex
					and  (YEAR(@i_Oper_Date-card.Date_birth)-1900) between @v_old_start and @v_old_finish
					and @i_Oper_Date between pc.Date_trans and pc.date_depart
					and people.out_date='2099-01-01'
					and ds.id_hr_dog= @DogID
					
				OPEN PeopTab  
				FETCH NEXT FROM PeopTab INTO @auto_card, @pid, @prid;
				WHILE @@FETCH_STATUS = 0  
					BEGIN  
					insert into user_mc_cust_dog_type_people (dog_id, dog_type_id, auto_card, pid, prid, Date_Modify, UserName)
					values (@dog_ident, @med_ident, @auto_card, @pid, @prid, getdate(), SUSER_SNAME());

				FETCH NEXT FROM PeopTab INTO @auto_card, @pid, @prid;
				END  
  
				CLOSE PeopTab;
				DEALLOCATE PeopTab;
			--	End;	

А вот так уже нет:
			---------------------------------3----------------------
				DECLARE PeopTab CURSOR FOR   
					select people.auto_card,people.pid, pc.prid
					from people
					inner join pr_current pc on pc.pid=people.pid
					inner join card on card.auto_card=people.auto_card
					inner join user_hrtb_dog_struct ds on ds.id_hr_struct=pc.Code_struct_name
					where 
					card.sex=@v_sex
					and  (YEAR(@i_Oper_Date-card.Date_birth)-1900) between @v_old_start and @v_old_finish
					and @i_Oper_Date between pc.Date_trans and pc.date_depart
					and people.out_date='2099-01-01'
					and ds.id_hr_dog= @DogID
							and people.pid not in (select p.pid 
							from user_mc_cust_dog_type_people p
							inner join user_mc_cust_dog d on p.dog_id=d.id
							and d.id_hr_dog=@DogID
							and d.tYear=@i_tYear)
					
				OPEN PeopTab  
				FETCH NEXT FROM PeopTab INTO @auto_card, @pid, @prid;
				WHILE @@FETCH_STATUS = 0  
					BEGIN  
					insert into user_mc_cust_dog_type_people (dog_id, dog_type_id, auto_card, pid, prid, Date_Modify, UserName)
					values (@dog_ident, @med_ident, @auto_card, @pid, @prid, getdate(), SUSER_SNAME());

				FETCH NEXT FROM PeopTab INTO @auto_card, @pid, @prid;
				END  
  
				CLOSE PeopTab;
				DEALLOCATE PeopTab;
			--	End;			
				-------------------------конец 3-------------------