select * from rw_tasks where charindex(',wqz,',','+users)>0 and state='0'
create #temp ( id int,users nvarchar(100) , state nvarchar(100)) declare @s varchar(100),@h varchar(100),@r varchar(100) declare @p int,@m int set @m = 0 SELECT @@CURSOR_ROWS DECLARE authors_cursor CURSOR FOR SELECT users,state FROM rw_tasks OPEN authors_cursor FETCH authors_cursor INTO @s,@h WHILE @@CURSOR_ROWS = 0 begin IF charindex(@s,'wqz') > 0 set @p = pos(@s,'wqz') set @r = left(@s,@p - 1) WHILE charindex(@r,',') > 0 begin @m = @m + 1 end @r = substring(@h,@m + @m,1) insert #temp values(select * from rw_tasks where state = @r) end end CLOSE authors_cursor DEALLOCATE authors_cursor select * from #temp
where charindex(',wqz,',','+users)>0 and state='0'
declare @s varchar(100),@h varchar(100),@r varchar(100)
declare @p int,@m int
set @m = 0
SELECT @@CURSOR_ROWS
DECLARE authors_cursor CURSOR FOR
SELECT users,state FROM rw_tasks
OPEN authors_cursor
FETCH authors_cursor INTO @s,@h
WHILE @@CURSOR_ROWS = 0
begin
IF charindex(@s,'wqz') > 0
set @p = pos(@s,'wqz')
set @r = left(@s,@p - 1)
WHILE charindex(@r,',') > 0
begin
@m = @m + 1
end
@r = substring(@h,@m + @m,1)
insert #temp values(select * from rw_tasks where state = @r)
end
end
CLOSE authors_cursor
DEALLOCATE authors_cursor
select * from #temp