Hi, My cursor stops after hitting a rollback. How can i continue processing after a rollback occurs?

Thanks, Greg

Here is my code:

DECLARE @supplied_date DATE SELECT @supplied_date = '2014-12-10' //Change the supplied date

DECLARE service_fut_curs CURSOR FOR SELECT service_code FROM service_future WHERE effective_date > @supplied_date

DECLARE @future_code        varchar(20)
DECLARE @existing_code      varchar(20)
DECLARE @rowcount           INT

OPEN service_fut_curs WITH HOLD         
FETCH service_fut_curs INTO @future_code

WHILE (@@sqlstatus = 0) 
BEGIN     
    SELECT service_code 
      INTO @existing_code
      FROM Service
     WHERE service_code = @future_code and active = 'Y'

    /* Move existing service to the service_hist table */
     INSERT INTO service_hist 
        (service_code, description, service_class, service_type, wt_low, wt_high, piece_cost, wt_cost, 
         vendor_id, ww_zone, last_ws, last_user, last_date, last_time, "comment", active, effective_date, country_code,
         level_id, bill_zone1, bill_zone2, bill_zone3, bill_zone4, bill_zone5, mail_class_id, pri_min_wt, pri_max_wt, actual_country_code, active_date,
         inactive_date, product_code, currency_code, volume_piece_min, volume_piece_max, matrix_id, piece, piece_wt, wt,
         hts_code, value_range_from, value_range_to) 
     SELECT service_code,description,service_class,service_type,wt_low,wt_high,piece_cost,wt_cost,
            vendor_id,ww_zone,last_ws,user,today(),now(),"comment",'N',effective_date,country_code,
            level_id,bill_zone1,bill_zone2,bill_zone3,bill_zone4,bill_zone5,mail_class_id,pri_min_wt,pri_max_wt,actual_country_code,active_date,
            inactive_date,product_code,currency_code,volume_piece_min,volume_piece_max,matrix_id,pieces,piece_wt,wt,
            hts_code,value_range_from,value_range_to 
       FROM service 
      WHERE service_code = @existing_code

    IF @@ROWCOUNT = 0
    BEGIN
        Select  'Warning: No rows were inserted into service_hist '
        ROLLBACK
    END

    IF @@ROWCOUNT = 1
    BEGIN
        Select  'Success: 1 row was inserted into service_hist '
        COMMIT

        -- Delete existing service from the service table
        DELETE FROM service WHERE service_code = @existing_code
        IF @@ROWCOUNT = 0
        BEGIN
            Select  'Warning: No rows were deleted FROM service'
            ROLLBACK
        END

        IF @@ROWCOUNT = 1
        BEGIN
            SELECT 'Success: 1 row was deleted FROM service'
            COMMIT
            --Insert New service into the service table
            INSERT INTO service (service_code,description,service_class,service_type,wt_low,wt_high,piece_cost,wt_cost,
                        vendor_id,ww_zone,last_ws,last_user,last_date,last_time,"comment",active,effective_date,country_code,
                        level_id,bill_zone1,bill_zone2,bill_zone3,bill_zone4,bill_zone5,mail_class_id,pri_min_wt,pri_max_wt,actual_country_code,active_date,
                        inactive_date,matrix_id,hts_code,value_range_from,value_range_to,pieces,piece_wt,
                        product_code,currency_code,volume_piece_min,volume_piece_max)
            SELECT service_code,description,service_class,service_type,wt_low,wt_high,piece_cost,wt_cost,
                   vendor_id,ww_zone,last_ws,user,today(),now(),"comment",'Y',effective_date,country_code,
                   level_id,bill_zone1,bill_zone2,bill_zone3,bill_zone4,bill_zone5,mail_class_id,pri_min_wt,pri_max_wt,actual_country_code,active_date,
                   inactive_date,matrix_id,hts_code,value_range_from,value_range_to,pieces,piece_wt,
                   product_code,currency_code,volume_piece_min,volume_piece_max
              FROM service_future 
             WHERE service_code = @existing_code

            IF @@ROWCOUNT = 0
            BEGIN
                Select  'Warning: No rows were inserted into the service table'
                ROLLBACK
            END

            IF @@ROWCOUNT = 1
            BEGIN
                Select  'Success: 1 row was inserted into the service table'
                COMMIT 
                      DELETE FROM service_future WHERE service_code = @existing_code 
                IF @@ROWCOUNT = 0
                BEGIN
                    Select  'Warning: No rows were deleted From service_future table'
                    ROLLBACK
                END

                IF @@ROWCOUNT = 1
                BEGIN
                    SELECT 'Success: 1 row was deleted From service_future table'
                    COMMIT
                END
            END -- check insert into service table
        END -- Check deleted FROM service'
    END -- check inserted into service_hist

    SELECT @rowcount =  @rowcount + 1
    FETCH NEXT service_fut_curs INTO @future_code        
END -- loop

CLOSE service_fut_curs         
DEALLOCATE service_fut_curs