select Analit, MestoReg, GruppaDel from MBAnalit where Vid = 3174 and GruppaDel in (1149019,1381767,1643779,1381830,1405671,1643810) -- 6682 

--1) ВХОДЯЩИЕ РКК   
SET DATEFORMAT DMY
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
declare @Analit int, 
    	@mr int,
	    @gd int
    

declare CRS cursor LOCAL FAST_FORWARD for        
  select Analit, MestoReg, GruppaDel from MBAnalit where Vid = 3174 and GruppaDel in (1149019,1381767,1643779) -- 1355     
open CRS
fetch CRS into @Analit, @mr, @gd
while @@FETCH_STATUS = 0
begin        

--update MBAnalit set MestoReg = ?, GruppaDel = ? where Vid = 3174 and Analit = @Analit
                   
fetch next from CRS into @Analit, @mr, @gd
end
close CRS
deallocate CRS      
SET NOCOUNT OFF 


--2) ИСХОДЯЩИЕ РКК
SET DATEFORMAT DMY
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
declare @Analit int, 
    	@mr int,
	    @gd int
    

declare CRS cursor LOCAL FAST_FORWARD for        
  select Analit, MestoReg, GruppaDel from MBAnalit where Vid = 3174 and GruppaDel in (1381830,1405671,1643810) -- 5327    
open CRS
fetch CRS into @Analit, @mr, @gd
while @@FETCH_STATUS = 0
begin        

--update MBAnalit set MestoReg = ?, GruppaDel = ? where Vid = 3174 and Analit = @Analit
                   
fetch next from CRS into @Analit, @mr, @gd
end
close CRS
deallocate CRS      
SET NOCOUNT OFF