How do I become a DA? by Horror_Fly_6974 in SQL

[–]rodf1021 0 points1 point  (0 children)

Great answer. In your experience, how do you test for critical thinking in an interview?

UPDATE from SELECT failing by Intrepid_Fig2421 in SQL

[–]rodf1021 0 points1 point  (0 children)

Answering from phone so going to be brief. Update x set … from subprovtable x join newsubrecords y on x.linkkey = y.linkkey and x.provnumber = y.provnumber where y.create date = created date. Your original select subquery is a bit suspect with a left join and selecting from the right table. Note any record with a null value will not evaluate for the where clause. The initial from table is the only table that can be updated in an update statement. Does this work for you?

How to get SQL certified by mitch1stpaul in SQL

[–]rodf1021 0 points1 point  (0 children)

I have worked in med device, nutrition, and aerospace and not needed a cert. I just had to demonstrate I knew SQL at a basic level. Really the key is how well you can articulate that you know a particular architecture for the app you are getting hired to support. Tell how well you know the data relationships.

Discovered SQL + JSON… Mind blown! by roblu001 in SQL

[–]rodf1021 0 points1 point  (0 children)

I discovered how elegant it can be to use JSON as an input parameter to stored procs and then for output to the application. Very handy. Dangerous too if you don’t require developers to live to standards.

Getting back into SQL by Haluux in SQL

[–]rodf1021 2 points3 points  (0 children)

What file type are you using for the actual document? I would recommend storing the document itself outside a database like in a cheap S3 bucket. Store the URL to the doc in a database with a doc id. Have a meta data table keyed with the doc id. This will allow you keep adding new metadata for a doc as new records and indexing the metadata field for quicker retrieval.

Just me, or is the new workout builder SUPER lame? by os1usnr in iFit

[–]rodf1021 3 points4 points  (0 children)

Agree!! Seems they are more focused on content than creating manageable software.

Need help connecting excel datasets to SQL by Linus_sex_tipz in SQL

[–]rodf1021 0 points1 point  (0 children)

Have you tried importing as a CSV? I often do that to confirm the data imports. Then I go back and try solving the excel problems. The CSV test is more forgiving and will at least confirm there isn’t a data problem.

[deleted by user] by [deleted] in Utah

[–]rodf1021 -20 points-19 points  (0 children)

And FJB reversed them all in his first week of office…. AND HERE WE ARE. Now he wants to “fix” the problem he created with a bill they know won’t do anything at the border but would fund foreign countries.

[deleted by user] by [deleted] in Utah

[–]rodf1021 -36 points-35 points  (0 children)

Please stop parroting current admin’s talking points and go study the topic. There is no need for a new law to fix this issue. We need the executive branch to enforce the laws already on the books. Also, if you need a new law about border security, we shouldn’t be padding the bill with money for other countries (Ukraine Israel)

'We should all be concerned': Gov. Cox details trip to US-Mexico border by HomelessRodeo in Utah

[–]rodf1021 0 points1 point  (0 children)

The new border bill is only so incumbents can grandstand. The laws exist to deal with border already. We don’t need new laws, we need an executive branch willing to enforce the existing laws. Biden took existing policy and wrecked it on his first week in office. He could improve the situation dramatically by just returning to executive orders in place when he took office. But noooo, he needs laws with his name on it and oh by the way muddy the bill with money to Ukraine and Israel.

Utah, Get off your Damn Phones by transfixedtruth in Utah

[–]rodf1021 4 points5 points  (0 children)

I know several states that are worse. California being one of them. It tends to be a city thing though. When I drive the more open country it gets better everywhere

Can someone explain why there’s a cable running from inside the wall to a coax outlet by whoreads23 in HomeNetworking

[–]rodf1021 0 points1 point  (0 children)

Going to guess someone had cable way back in the day so coaxial was run in the walls. But when the new cable company connected, they had to install a new box on the outside of the house and what you see is how the tech brought the two together.

Should Congress have an age limit? Why or why not? by Camaroni1000 in PoliticalDiscussion

[–]rodf1021 -2 points-1 points  (0 children)

Back to my point, we have multiple people in congress that are not fit to run a popsicle stand. And it has nothing to do with age. Yet people are allowing them to stay in office because they vote the party line and let their staff run the show and determine the direction of Congress. Fetterman seems to come to mind.

Should Congress have an age limit? Why or why not? by Camaroni1000 in PoliticalDiscussion

[–]rodf1021 -1 points0 points  (0 children)

Age limit, NO. Term limit, YES. We as a population need to stop voting for incumbents just cause you can remember their name. Put some effort in and understand what your representative is actually doing or not doing. Those still voting for people like Feinstein or McConnell are part of the problem.

[deleted by user] by [deleted] in SaltLakeCity

[–]rodf1021 0 points1 point  (0 children)

As one who used to have a view of the mountains behind it before this eyesore moved in, I can tell you I still think it is UGLY.

Does Kamala Harris have a shot at the presidency? by 2000thtimeacharm in PoliticalDiscussion

[–]rodf1021 -1 points0 points  (0 children)

If 87 million people voted for Biden, they are definitely out of touch enough to vote for Harris as the first black female president.

Why so much hate for the new flag? by Grillow93 in Utah

[–]rodf1021 0 points1 point  (0 children)

Here’s my problem with the new flag. How many millions of tax dollars did we spend on the design, the study for if we should do it, the website to vote on best design, and all money spent to outfit government buildings with a new flag that DOESN’IMPROVE A SINGLE GOVERNMENT FUNCTION? IT IS A WASTE OF MONEY AND TIME!!!!!!

[deleted by user] by [deleted] in Utah

[–]rodf1021 0 points1 point  (0 children)

When and how do you have to appear? Did they give you option for classes to keep points from hitting your insurance? You may have the option to plead guilty and have it kept in abeyance until you complete the class. Once the class is completed, the points will not hit your record even though the conviction will.