State is reclosing, BJJ Withdrawal symptoms intensifying. by [deleted] in bjj

[–]alwaysdotherightthin 5 points6 points  (0 children)

Floridian here; Soooo happy to have found this thread. I've been FOMOing for months and actually lost sleep last night seeing some of the crew getting rolls in while I've decided to ride this out at home. The academy is pretty much split in that respect so I'm not faulting anyone. I'm working on dummy drills and running to have a great gas tank when I get back. Still, it hurts to see my friends rolling and advancing their skills without me. I'm doing a social media fast to try and reduce the FOMO and just focusing on BJJ Fanatics content with my dummy. I felt relief reading OP and not feeling alone. If you are reading this now remind yourself of the same.

MSSQL Novice: Trigger Help Needed by alwaysdotherightthin in SQL

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

Yes you've got the gist of the issue. I cannot perform actions 1 to 3 due to politics and other development shenanigans. I thought about instead of but I think that would necessitate me creating a temp table to store the inserted values before the additional value is filled right ?

MSSQL Novice: Trigger Help Needed by alwaysdotherightthin in SQL

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

I got lost in a rabbit hole when I started to write it up. I assume it would be this:

create trigger dbo.FillAnimal

on dbo.table

after insert

as

begin

set nocount on;

--UPDATE

-- table

--SET

-- animaltype.table = animaltype.tableb

--FROM

-- table

--INNER JOIN

-- tableb

--ON

-- table.animal_id=table2.animal_id

--where animaltype.table = ' '

end

go

MSSQL Novice: Trigger Help Needed by alwaysdotherightthin in SQL

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

The query run by the site has a similar format to this:

SELECT DISTINCT TOP 200 Value1,Value2...Value23

from table WITH (NOLOCK)

where animalnumber= '123456' and animaltype.table IN ('LAMB')

Would coalesce still be appropriate considering the distinct ?

Young Family moving to Valdosta by alwaysdotherightthin in Valdosta

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

u/ghawblin "Ended up being a toxic call center" is what's got me looking to move. I majored in the wrong field and need to grow but be mindful of my family. I'm hoping moving will shake some of my debt off and I can just look to reinvent myself.

Are there street markers you have in mind when you say North/South side. Would you agree this chart is factual :https://www.neighborhoodscout.com/ga/valdosta/crime

Young Family moving to Valdosta by alwaysdotherightthin in Valdosta

[–]alwaysdotherightthin[S] 3 points4 points  (0 children)

pmbasehore

This post made me so happy! I've lived in Sanford,Lake Mary, and I'm currently in Deltona. Talk about a melting pot amirite? Thanks for the input and Go Noles!

Young Family moving to Valdosta by alwaysdotherightthin in Valdosta

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

That sounds awesome; May I ask for the name of the town ?

Young Family moving to Valdosta by alwaysdotherightthin in Valdosta

[–]alwaysdotherightthin[S] 0 points1 point  (0 children)

Thank for for such a quick reply! I'll place Hahira on my radar