this post was submitted on 03 Aug 2023
-3 points (40.0% liked)
Technology
58138 readers
4572 users here now
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related content.
- Be excellent to each another!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, to ask if your bot can be added please contact us.
- Check for duplicates before posting, duplicates may be removed
Approved Bots
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Your here now already, ask your question.
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