![](/static/253f0d9b/assets/icons/icon-96x96.png)
![](https://fry.gs/pictrs/image/c6832070-8625-4688-b9e5-5d519541e092.png)
At this point I try to disregard anything that I can tell is SEO generated though, I wonder how many more feel like me.
At this point I try to disregard anything that I can tell is SEO generated though, I wonder how many more feel like me.
I’m still wanting the “marked as read” option though, I’m not a huge fan of having to vote on everything.
Absolutely no capitalization? That always makes me back away. You can’t even be bothered to make a proper sentence?
Partay?
Or Instanbul
I didn’t know which post to reply to, so here goes: with one as (select top 1 field1, replace(field2_html,‘’‘"]|([‘’"]).?\1)*>’, ‘’) as comments_html, field3, field4, field5, field6, field7, field8 from tablea where comments_html !=’ '),
two as
(select field1, field2 as html_clean, charindex(‘<’,field2_html) as a, charindex(‘>’,field2_html) as b, field3, field4, field5, fied6, field7, field8
from one)
select * into #temp8 from two
create table #RUdestinationtable (field1 int, comments_2 varchar(max), field3 varchar(300), field4 varchar(50), field5 varchar(300), field6 varchar(300), field7 varchar(300), field8 varchar(150))
while (select count(1) from #temp8 where substring(html_clean,a,b) is not null)>0 begin insert into #RUdestinationtable select distinct field1,replace(html_clean, substring(html_clean,a,b),‘’) as comments_2,field3, field4, field5, field6, field7, field8 from #temp8 end
select * fromRUdestinationtable
Mine was in surgery yesterday. I hope yours is doing well.