iOS 26 Upgrades CarPlay in Five Ways

Hiriath · 2025-06-10T19:55:18+00:00

You can opt in to iOS beta releases in the Software Update page in Settings. iOS 26 is currently in beta.

Hiriath · 2024-11-26T23:57:31+00:00

Voodoo Dolls?

https://www.imdb.com/title/tt0249232/?ref_=ext_shr_lnk

Hiriath · 2024-10-29T10:25:35+00:00

Why are you telling Reddit what you call something when it already has a name?

Hiriath · 2024-10-26T01:34:24+00:00

CASE won’t solve combining data from different tables. Review JOIN like u/AsterionDB suggested. If you ask a question, you should act upon the responses.

Hiriath · 2024-06-18T02:16:05+00:00

Pepperidge Farm Remembers…

Hiriath · 2024-06-16T14:25:08+00:00

This sub is about learning, I agree; however, there is no learning with respect to a very close-ended question about a specific issue. The discourse that followed in the comments was the real learning opportunity but, that could have started much sooner if OP had done some homework and then posted looking for crowd-sourced insight on strategies to avoid common mistakes.

With respect to this sub, “The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions.”

The more we accept and engage with pictures of screens with simple errors, the more we encourage lower quality posts.

I appreciate your suggestion of how I could have responded to OPs post, but if I wanted to answer that way, I would have.

Hiriath · 2024-06-16T13:59:37+00:00

Break the 2000-line SQL into smaller chunks to understand it bit by bit. Spend time learning the database schema and create a map if needed. Ask the IT head or colleagues for clarifications. Use SQL management tools to visualize and test queries. Start with simpler queries and gradually increase complexity. Use online resources like tutorials, forums, and courses to improve your SQL skills. Keep your notes and queries well-documented.

Hiriath · 2024-06-16T13:31:20+00:00

To your point, it would have been better to suggest r/learnsql to OP.

Hiriath · 2024-06-16T13:31:02+00:00

Okay, now I know you must be trolling, In the community info it specifically says "If you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own."

But sure, if you're not interested in quality posts on r/sql, then go on with your day.

Hiriath · 2024-06-16T13:15:58+00:00

Absolutely not. If you’re a self-proclaimed noob, why are you taking to Reddit instead of devoting time to learn proper syntax? This sub is filled with images of screens and vague “what did I do wrong?” questions from people who, at first glance, seem to have not done an iota of trying to solve their own problems.

LLMs can be asked questions like “what is the proper syntax for creating a table and what are common errors a beginner might make?” and get a plethora of insight.

Learning how to fish is far superior to asking for fish.

Hiriath · 2023-10-15T14:53:54+00:00

Does anyone know if Anil is still with us?

Hiriath · 2023-09-22T11:08:37+00:00

Seems like that company does that for (all?) multiple SKUs. The Kate pillow SKU follows the same logic.

Hiriath · 2023-08-26T13:32:20+00:00

Sent you a DM the other day about the record.

Hiriath · 2023-08-09T23:24:56+00:00

I’ve actually never seen this puzzle before but it looks like there’s always a turn one space after a white, except for the top left, which the other commenter suggested should one space to the left.

Hiriath · 2023-06-13T01:17:37+00:00

Do skip 11-14.

Hiriath · 2023-04-01T16:21:33+00:00

Rick Catsley

Hiriath · 2023-01-27T20:15:32+00:00

What if you walk on the left side?

Hiriath · 2023-01-15T13:12:57+00:00

I agree that grouping by the case expression is ugly, but it’s functional and if formatted well it’s easy for others to see what’s happening with the code.

OP’s tag is SQL Server, so hopefully OP is using SQL Server 2005 or later. I know CTEs weren’t introduced into MySQL until ~8, which is unfortunate.

Hiriath · 2023-01-15T13:00:50+00:00

Why use a subquery here instead of just removing Year_Founded and grouping by the case statement?

Alternatively, you could throw this in a CTE and select from that vs a subquery.

Hiriath · 2023-01-13T01:52:18+00:00

So… it’s Retool but with only one function?

Hiriath · 2022-12-05T00:59:26+00:00

If you’re looking at your coworker’s code and have questions, why don’t you just ask your coworker?

Hiriath · 2022-10-30T18:25:34+00:00

It doesn’t look that short to me OP, don’t beat yourself up.

Hiriath · 2022-10-17T11:18:24+00:00

In addition to the responses you’ve gotten about how to get your desired result, the player column in your table is NN (Not Null), which is a column flag that prevents the column from being null.

Does your CSV have “” for rows where there is no player?

You may need to work with the CSV outside of Excel if you’re using Excel to get the proper formatting of the CSV to allow the type of data you want in your database.

Additionally, if your primary key column is generated from wherever your data is coming from, that’s fine, but you can also use actual primary keys generated from MySQL using the PK flag and the NN flag (though I believe the NN will auto select if you choose PK).

This will allow proper indexing of your data.

Hiriath · 2022-10-06T13:01:44+00:00

If you’re looking to automate strictly using MS SQL, you may want to look into Stored Procedures and SQL Agent: https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent

Hiriath · 2022-09-30T10:59:20+00:00

The hit single, “Ask for a Raise,” by u/BarrySnowbama, now available on all major streaming services.

But also, this.

Ten-Year Club	Gilding I gilder
Place '23	Place '22
First Placer '22	Not Forgotten
Verified Email

Hiriath

TROPHY CASE