declare mycursor cursor
 for select id,DeptName from tabtest 
open mycursor     
 
    declare @id int,@deptname varchar(20)    
    declare @id_Old int,@deptname_Old varchar(20)
    declare @sql varchar(100)
    
    fetch next from mycursor into @id,@deptname   
    while @@fetch_status=0   
    begin 
        if(@deptname is null)
            begin
                set @sql=' update tabTest set deptname='''+@deptname_Old+''' where ID = '+cast(@id as nvarchar);
                print @sql;        
                exec(@sql)        
            end
        set @id_Old=@id 
        set @deptname_Old=@deptname
        fetch next from mycursor into @id,@deptname    
    end  
close mycursor  
deallocate mycursor