SQL 字段取字符位置与循环修改数据

declare @ReWorkTable table(RowNumber int, TaskID int)
insert into @ReWorkTable
select row_number() over (order by gzrw_id), gzrw_id from tworktask where gzrw_tasktype = 7 and gzrw_state = 0 and gzrw_project_id = 38
declare @pos int
declare @count int
select @count = count(RowNumber) from @ReWorkTable
 --print @count
set @pos = 1
while (@pos <= @count)
begin
  declare @id int
  select @id = TaskID from @ReWorkTable where RowNumber = @pos
  --print @id
  declare @gzrw_name varchar(100)
  select @gzrw_name = gzrw_name from tworktask where gzrw_id = @id
  --print @gzrw_name
  declare @tag int
  select @tag= charindex('入',@gzrw_name)
  --print @tag
  declare @gzrw_name_temp varchar(100)
 select @gzrw_name_temp=substring(@gzrw_name,1,@tag)
  --print @gzrw_name_temp
 declare @gzrw_worker_id int
 select @gzrw_worker_id=gzrw_worker_id From tworktask where gzrw_name =@gzrw_name_temp
  --print @gzrw_worker_id
 update tworktask set gzrw_worker_id=@gzrw_worker_id where gzrw_id=@id

 set @pos = @pos + 1
end

IF @@ERROR <> 0
print '成功修改条数:'+@count