asked on
declare @uniqueid int;
declare @column2 nvarchar(100);
declare @last_column2 nvarchar(100);
declare @cnt int;
declare cur cursor for
select uniqueid, [col2]
from dbo.aTest
where [col1] = 'AA'
order by uniqueid
open cur
fetch next from cur into @uniqueid, @column2
set @last_column2 = ''
set @cnt = 0
while @@fetch_status = 0
begin
if @last_column2 = '' or (len(@column2)> 1 and @cnt > 1)
set @last_column2 = @column2
update a
set Col3Update = @last_column2
from dbo.aTest a
where uniqueid = @uniqueid
set @cnt = @cnt + 1
fetch next from cur into @uniqueid, @column2
end
close cur;
deallocate cur;
select * from dbo.aTest
order by uniqueid