Create proc dbo.usp_cut_tbl_store_date 
@year smallint, 
@qq tinyint, 
@part int                       
--,@md smallint 
as 
/* 
DECLARE  
@year smallint, 
@qq tinyint, 
@part int ,                        
@md smallint 
 
SET @year = 2012 
SET @qq = 2 
SET @part = 1000 
--SET @md = 2014 
*/ 
 
WHILE 2=2  
    BEGIN 
        SET rowcount @part           
         
        create table #tbl_store ( 
        id  numeric(18, 0)  not null, 
        year_   smallint    not null, 
        qq_ tinyint not null, 
        member_id   numeric(18, 0)  not null, 
        complect_code   varchar(20) not null, 
        chances decimal(14, 10) not null, 
        state   tinyint DEFAULT    0        not null, 
        num smallint    not null, 
        shop_del    tinyint null, 
        constraint PKa_tbl_store_id PRIMARY KEY NONCLUSTERED ( id ) 
        ) 
 
	create nonclustered index NCI_id 
        on #tbl_store (id) 
        on 'default'

        create nonclustered index NCI_year_qq 
        on #tbl_store (year_,qq_) 
        on 'default'
 
        insert  #tbl_store  
        (id,year_,qq_,member_id,complect_code,chances,state,num,shop_del) 
        
	select  tbl_store.id, tbl_store.year_, tbl_store.qq_, tbl_store.member_id, 
		tbl_store.complect_code, tbl_store.chances, tbl_store.state, 
		tbl_store.num, tbl_store.shop_del 
	from tbl_store 
 
        IF @@rowcount =0 Break   
   
        SET ROWCOUNT 0   
 
        BEGIN TRAN 

	    INSERT M..a_tbl_store 
            (id,year_,qq_,member_id,complect_code,chances,state,num,shop_del)
 
            SELECT #tbl_store.id, #tbl_store.year_, #tbl_store.qq_,  
		   #tbl_store.member_id, #tbl_store.complect_code, 
		   #tbl_store.chances, #tbl_store.state, #tbl_store.num, 
		   #tbl_store.shop_del 
            FROM #tbl_store (index NCI_year_qq) where year_=@year and qq_=@qq
 
                IF @@error <>0 goto  lab1                                
                    DELETE tbl_store where id IN (SELECT id FROM #tbl_store (index NCI_id )) 
--                    DELETE tbl_store where id IN (SELECT id FROM #tbl_store where year_=@year and qq_=@qq) 
                IF @@error <>0 goto lab1             
        COMMIT TRAN 
--        PRINT 'Cutting Period %1!,%2!', @year ,@qq 
 
    DROP index #tbl_store.NCI_id
    DROP index #tbl_store.NCI_year_qq 
    DROP TABLE #tbl_store 
    END       
    waitfor delay "00:00:10"                        
RETURN 0 
 
lab1:                         
ROLLBACK TRAN 
RETURN -1 
go

SETUSER
go

IF @@rowcount =0 raiserror 99999 
		'There are no values in this range %1! - %2!.',@min_,@step2

Select @Min = MinValue from the Table_WhichStore_ResultsOfExecution
Set @Max = @Min + @BatchSize
Set @RC = 0
while (@RC < @BatchSize) and (@Max < [@Max_ID]) --where @Max_ID - maximum value of the identifier at the table
begin
  Set @Max = @Max + @BatchSize/10
  select @RC = count(*) from SourceTable where ID between @Min and @Max
end