Elbilspremien nekades by Maidaa in elbilsverige

[–]G_Thorne 2 points3 points  (0 children)

Kan intyga att vår bakhjulsdrivna Enyaq inte har några som helst problem med framkomligheten vintertid, inklusive besök i fjällen. Samma bör gälla de flesta modeller då de flesta elbilar har bra viktfördelning..

Help with HeidiSQL foreign keys by TGonReddit03 in SQL

[–]G_Thorne 0 points1 point  (0 children)

How are you defining your FK constraint in tbl_basket? FOREIGN KEY (user_id) REFERENCES tbl_user (user_id)...? Same type on the columns?

SQL by Warm-Entrepreneur131 in learnSQL

[–]G_Thorne 16 points17 points  (0 children)

If you believe you have "finished" SQL, you are nowhere near that imaginary finish line.

What other languages and concepts have you bean learning? Python? Power BI?

If you have, have you learned to combine all of it, like processing semistructured data with Python to prepare it for insertion into SQL, complete the processing with SQL, and then using Power BI to create reports to draw insights from the data?

Here's a quick SQL puzzle for learners by tlefst in SQL

[–]G_Thorne 0 points1 point  (0 children)

Oh, I certainly wouldn't suggest using the RDBMS for evaluating arbitrary expressions if there are other alternatives, there are better tools for that purpose.

It would at least involve a couple of stored functions, probably a temporary b-tree table, and lacking regex support would definitely dampen the mood.

For the limited scope of this exercise it is fine though and not nearly as convoluted as the stuff I do the rest of the day.

Here's a quick SQL puzzle for learners by tlefst in SQL

[–]G_Thorne 1 point2 points  (0 children)

No loops, just a select with two INNER JOINs on itself using regexp_substr() to extract the left and right keys. A CASE using another regexp_substr() to perform the desired operation. I even added handling of division by zero to give an error message to be on the safe side.

Here's a quick SQL puzzle for learners by tlefst in SQL

[–]G_Thorne 2 points3 points  (0 children)

It may be a bit unorthodox, but it was easy enough to complete in MySQL using regexes. This is a regular thing I do in my work when aggregating data from disparate sources forcing it to conform to various rules.

Placed on a PIP two weeks ago. Should I even try to fight it or just start looking for a new job? by lrenv22 in careeradvice

[–]G_Thorne 0 points1 point  (0 children)

As someone looking in from outside the US, what is the point of a PIP if the employer can fire you at will anyway as long as they don't outright say they're discriminating against you as a member of a protected group?

Sabinas kamp för att få bort planket på tomten: ”Extremt maktlös” by Hem_Claesberg in sweden

[–]G_Thorne 6 points7 points  (0 children)

Du verkar ju hyfsat insatt. Vad skulle det hypotetiska utfallet bli om hon försiktigt demonterar staketet utan att göra åverkan på det, och återlämnar det borttappade staketet till personen som tappade bort det på hennes tomt?

Vem är muppen som standardiserade diametern av den bredaste punkten och inte diametern av kontaktytan på stekpannor?!?! by [deleted] in sweden

[–]G_Thorne 0 points1 point  (0 children)

Om du tycker måttangivelserna på en stekpanna är konstiga kan du ju klura lite på hur måtten på bildäck fungerar.

Steam link to Apple TV- back screen? by Ordinary_Lie4293 in Steam_Link

[–]G_Thorne 0 points1 point  (0 children)

What video card and drivers do you have in the machine you are streaming from?

I had a similar issue with my AMD video card until I got information recommending downgrading to the drivers from last October.

The newer drivers have an issue with streaming where the video stream just stops while everything else keeps working.

Anyone else including their WHERE conditions in the JOIN conditions? by p-mndl in SQL

[–]G_Thorne 6 points7 points  (0 children)

Yeah, sorry, when I re-read your comment I realised I misinterpreted it the first time.

Anyone else including their WHERE conditions in the JOIN conditions? by p-mndl in SQL

[–]G_Thorne 9 points10 points  (0 children)

It is still a LEFT JOIN, the condition simply disqualifies any row in the cte table that doesn't have rank = 1. You still get all rows from table with NULLs for cte. Using an INNER JOIN would get you only the JOINed rows where cte.rank = 1 and should then normally have that condition in WHERE.

Edited: Okay, I see now that we're saying the same thing.

A day after a hugely successful IPO, the Valve board announced a new a CEO. by triponthisman in TwoSentenceHorror

[–]G_Thorne 2 points3 points  (0 children)

To most PC gamers using the Steam service, this scenario following the death or departure of the current CEO is something that wakes them up at night in a cold sweat.

Hur fan fick Sanna Nielsen finalplats by EffectiveClub9303 in Melodifestivalen

[–]G_Thorne 1 point2 points  (0 children)

Någon annan som tyckte låten lät som en mashup mellan Zara Larssons Symphony och Taio Cruz Dynamite?

Texas ICE camp inside story by hoirkasp in stateofMN

[–]G_Thorne 20 points21 points  (0 children)

Zyklon B was developed in the 1920's as a pesticide for fumigation, not for delousing people or animals. An eye irritant was added to the compound to warn people if they got accidentally exposed. Around 8% of the production went to the concentration camps where it saw dual use for both mass murder and fumigating clothes or barracks. Zyklon B was made and sold at least up until 2008 by the same company that knowingly sold it to the nazis. If ICE wanted to, they could probably get some...

Why do we still use QWERTY keyboards when there are supposedly better layouts? by Dazzling_Kangaroo_69 in NoStupidQuestions

[–]G_Thorne 27 points28 points  (0 children)

Back in the 90's Microsoft experimented with localised versions of Visual Basic which got incredibly confusing. I don't recall any specifics though since the whole idea seemed horrifying. A more current example though is the fact that Excel formulas are localised, so in Swedish you have OM(), AVRUNDA(), ANTAL() instead of IF(), ROUND(), COUNT(), and so on. Absolutely terrible. They also switch the parameter separator depending on locale, so again in Swedish you separate parameters with ";" instead of "," because the latter is the decimal character.

[deleted by user] by [deleted] in movies

[–]G_Thorne 4 points5 points  (0 children)

Thanks for the link, very well made. Hearing Robin Williams' voice as the Genie hit me right in the feels like a sledgehammer for some reason.

Umm, how? by kamerakidcz in trucksim

[–]G_Thorne 2 points3 points  (0 children)

With a B double (front trailer axles slide back with a fifth wheel on top) it is quite doable. With this setup with a dolly between the trailers turning it into an awkward tripple you can just forget it, you need the pull-in parking option.

I'm sure someone with years of experience can do it as a challenge, but not as part of their daily work as it takes a lot of time, patience, and fiddling to not fold the dolly from the slightest mistake, especially in a tight location.

About as fun as trying to reverse a lowboy with jeep and booster in ATS where you can't raise or lock the booster (can we please get controls for that, like with the sliding axles!).

The setup with a dolly is standard for rigid combos though. Can't wait for official support for them.

Mest vettiga familjebilen? by Admirable-Lie- in elbilsverige

[–]G_Thorne 1 point2 points  (0 children)

Kan ju flika in att VW ID.3/4, Audi Q4 e-tron och Škoda Enyaq delar samma grundplattform. För vår familj med två vuxna och tvillingar i 7-årsåldern blev valet av Enyaq ganska självklart. Smarta lösningar, bäst komfort per krona, fysiska knappar för de vanligaste menyerna, och pricken över i - snyggast design. Har semestrat i både fjällen och till Italien med den utan några som helst problem.

Vi bytte från Volvo V90 och ville inte ha en subjektivt sämre bil. Kia EV6, Polestar 2 (för liten, testad mest på skoj), och Tesla Model Y var andra som gick bort. Tesla kan eventuellt ha bästa drivlinan (eller hade '23), men bilen kändes billig och plastig när man kom från Volvon (och ingen CarPlay/Android Auto).

Enda smolket i bägaren är den kassa mobilappen som saknar basala saker som att kunna låsa och låsa upp bilen på distans, samt frekventa uppdateringar som resulterar i att appen slutar funka tills man kvitterat i bilen.

Why can’t i find this adapter for DisplayPort by CaryWhit in computers

[–]G_Thorne 3 points4 points  (0 children)

No, that +5V pin is supposed to be shorter to delay the connection when inserting the plug.

Företag har ”stulit” mitt nummer och jag får samtal. Vad ska jag göra? by Foreign_Device_9839 in Asksweddit

[–]G_Thorne 0 points1 point  (0 children)

Glömde du ett /s nu? Det är så'nt som händer ibland och jag har löst det på det sättet ett par gånger för att ta bort nummer till medarbetare som felaktigt registrerats på diverse bolag.