• 2 Posts
  • 25 Comments
Joined 1 year ago
cake
Cake day: June 9th, 2023

help-circle







  • So, I was in the same spot for a long time. The one thing I can suggest is to get a tiny portion of something you want to cook, for instance you want to make fried chicken at some point; in the beginning just get like 2 thighs that you aren’t planning on really eating. It’s literally just a test. The pressure is off for dinner that night and you get room to explore while still knowing if you have to throw it all away you are okay with it.












  • newbeni@lemmy.worldOPtoTechnology@lemmy.worldI need help with code
    link
    fedilink
    English
    arrow-up
    1
    ·
    11 months ago

    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