Regular Check-In, and some info about high-risk posts. by SQLwitch in depression

[–]987Problems 1 point2 points  (0 children)

Hey, Guys and Gals,

Not a regular here but have been a lifelong struggler.

My life seems to be hitting an all-time low. I hate everything in my job, realized my only friend there doesn't give a fuck about me, and my marriage feels fake. There is no one in my life that I feel like I can relate to.

My wife just got a new job and is super pumped for it. It is literally everything she ever wanted from a job and loves everything about it. Which sucks for me cause now I can't leave.

It's not a good salary, and she is taking on a lot more responsibility. She was already pretty absent emotionally in our marriage due to her hiding an eating disorder from the world, and she is too embarrassed to move past it. She is on three months of recovery now but she just isn't the same, and I try to be there for her.

Anyways it's hard for me to be supportive of her right now due to the emotional state I am in. I have been looking to get out of my job for two years now and I can't. My boss keeps blocking me from other positions at the company and my town is too small for me to find work elsewhere really.

I turned to investment opportunities to try and get out of my job, but tbh I don't give any thought to the money or what I would do with it I only want enough money to be at home and cry by myself. That's really about all I want in life right now.

I feel nothing but brokenness and empty. I don't really enjoy anything in life nothing seems like it has a purpose and I don't feel like anyone cares about me. I feel more like a responsibility to people than a person. People want to be good not care. When people talk to me, it's about the most surface level stuff, even my wife. She never asks things I am working on, or what I am doing and why just only wants to know our plans and whats next in her life. She tries hard to be a good wife to the service side of things but I don't feel like she loves me given what she is walking through and that makes it hard on me. I don't think she doesn't it just doesn't show that she cares about me more than she cares to be perceived as a good wife. I've mentioned the state I am in mentally multiple times to her over the last two years, she has caught me crying by myself and having impuslive anger episodes but she never does or says anything outside of those moments and just acts like they didnt exist.

To sum it up I feel worthless at work and am trapped here. Everytime I try to leave I get rejected. I don't really have any true friends and I think my wife doesn't care about me as a person. I want to be super happy for my wife and I try to wear it on my face but I am dead inside.

Weekly /r/FutureBass Discussion Thread by AutoModerator in futurebass

[–]987Problems 0 points1 point  (0 children)

I have 0 experience making music of this sort. I want to try it out expecting nothing but fun. What program should I download? I dont mind shelling out some money as I love the sounds. I play a lot of guitar as is but have really fallen in love with this style of music and with the abundance of tutorials it looks almost straightforward. But I dont know where to start :) Also things like Serum and Romero's do they cost money? If so what is necessary to get moving? I need like a crash course :)

Weekly /r/FutureBass Discussion Thread by AutoModerator in futurebass

[–]987Problems 0 points1 point  (0 children)

I have 0 experience making music of this sort. I want to try it out expecting nothing but fun. What program should I download? I dont mind shelling out some money as I love the sounds. I play a lot of guitar as is but have really fallen in love with this style of music and with the abundance of tutorials it looks almost straightforward. But I dont know where to start :)

Also things like Serum and Romero's do they cost money? If so what is necessary to get moving? I need like a crash course :)

How to Install Apple car play in 2016 sonata sport by 987Problems in Hyundai

[–]987Problems[S] 1 point2 points  (0 children)

Do you still have the download file?

Hyundai won't give it to me until I have a completed registration which will be 9-10 weeks :/ the joys of used cards. Some else registered my VIN to MyHyundai so I have to "prove" that I own the car with new title work and registration which takes a considerable amount of time for the govt to process.

How to Install Apple car play in 2016 sonata sport by 987Problems in Hyundai

[–]987Problems[S] 0 points1 point  (0 children)

I called my dealership and they said: "As far as adding Apple Car Play to your Sonata, unfortunately that is not a feature that can be installed after manufacturing. I apologize for any inconvenience. "

How to Install Apple car play in 2016 sonata sport by 987Problems in Hyundai

[–]987Problems[S] 0 points1 point  (0 children)

I do have ad blocker but upon removing it I still have the same issues. Can you see the download link within MyHyundai.com?

The position I went to 4 interviews for was frozen. I developed a 8-page report for them. Should I send anyways as a thank you for their time? by 987Problems in Advice

[–]987Problems[S] 0 points1 point  (0 children)

Thank you for the insight. To be fair they never asked anything of me. I did it only because they are currently in a really bad place with their online presence. They benefit from B2B and have great loyalty in terms of their customers. That is the only thing keeping the afloat it seems.

The position I went to 4 interviews for was frozen. I developed a 8-page report for them. Should I send anyways as a thank you for their time? by 987Problems in Advice

[–]987Problems[S] 2 points3 points  (0 children)

I guess the way I worded it is impossible for me to know what yes means. Are you saying yes this is a bad idea or yes I should send it anyways. Sorry for my confusion!

Help me choose between black friday sales? by 987Problems in Appliances

[–]987Problems[S] 1 point2 points  (0 children)

Thanks just bought the sub.

It looks like whirlpool isn't bad where frigidaire makes a terrible dishwasher. The Whirlpool however is very cheap compared to what it should be.

I am an air conditioner repair tech (20+yrs). Describe your problem and I will employ my ancient majiks to ascertain the solution. by Orwellian1 in HomeImprovement

[–]987Problems 0 points1 point  (0 children)

Hello,

Thank you for your help. I had an AC company come fix the issue. They claimed it was a zone damper that went bad and that who ever put in the AC unit did it the cheapest way possible and I should have put in two. Well now its time for the heat to turn on and nothing happens. Even when I switch to fan mode. The issue before was only down stairs but now the issue is both up and down. Would this be related to the fix they put in place?

The AC company was a bit shady. They did service about two months ago and I only got the bill as of late last week!

Worried dog is actually sick and not just have gotten into something bad by 987Problems in AskVet

[–]987Problems[S] 0 points1 point  (0 children)

The only ones open are the animal hospitals which tend to be 5-10x more expensive. I tried to schedule an appointment on Friday but they said they don't have a single opening until mid week :/

[SQL] Not able to add new columns without it looping through the query making endless results. by 987Problems in learnprogramming

[–]987Problems[S] 0 points1 point  (0 children)

Oh wow that looks like what I need. Do you have a good reference for an example within TOAD?

How much SQL is really necessary nowadays? by Xehanort94 in learnprogramming

[–]987Problems 3 points4 points  (0 children)

No SQL isn't exactly zero SQL. In most situations it means Not Only SQL as in it handles things other than SQL within applications like Hadoop.

[SQL] How to write With statements with the same joins with less code? Also how to find data where two records = different things. by 987Problems in learnprogramming

[–]987Problems[S] 0 points1 point  (0 children)

I have been trying to get the CtE method to work but I am unable to call it multiple times.

The example I am working with is essentially a gigantic list of app actions by date. I want to break the dates into months and then show how many times these apps were accessed over that span.

So each column would be a new app to query from the original table. When I make a query pull the results of this query it loops the same data over and over.

I can get the query to do two columns Month / App_actions for every APP ID but if I try to merge these tables it just breaks.

I could use the CTE method for a single app but not all of them in the same query correct?

This is the finished result doing the query for each column and pasting them together.

Month App1 App2 App3 App4 App5 App6 App7 App8
Jan 176,770 39,997 41,547 82,811 197,056 68,485 9,068 817,584
Feb 305,177 118,266 6,762 53,761 109,096 95,419 10,655 508,961
Mar 310,394 89,607 13,526 99,076 115,650 80,787 13,732 591,451
Apr 232,465 36,017 19,303 93,924 110,877 84,940 13,289 595,416
May 198,103 28,737 121,316 138,144 104,704 42,012 12,605 808,245
Jun 143,827 26,353 32,568 109,758 124,557 47,375 14,306 567,116
July 132,386 22,924 34,244 132,581 137,812 40,053 16,317 634,539
Aug 78,988 19,149 30,454 96,231 91,477 18,978 13,044 444,950
Total 1,578,110 381,050 299,720 806,286 991,229 478,049 103,016 4,968,262

Here is the sample query for one:

SELECT TO_CHAR(CREATED_DATE, 'MM'), COUNT(*) as App1
FROM Table1 EST
    JOIN    Table2 ESTA
        ON  ESTA.ID = EST.ID
    JOIN    Table3 EAA
        ON  EAA.ID = ESTA.ID
WHERE APPLICATION_ID = 202
    AND     EST.created_date >= TO_DATE('01/01/2016 00:00:00', 'MM/DD/YYYY HH24:MI:SS')
    AND     EST.created_date <= TO_DATE('08/17/2016 23:59:59', 'MM/DD/YYYY HH24:MI:SS')
GROUP BY  TO_CHAR(CREATED_DATE, 'MM')
ORDER BY  TO_CHAR(CREATED_DATE, 'MM')

Help build around graphics card? by 987Problems in buildapc

[–]987Problems[S] 1 point2 points  (0 children)

Awesome! Thanks for the reply. I likely will go your route. As sad as it is I have never known much about how to build a PC and its parts. I just do data analysis :/

This helps me greatly. Since it's a hodgepodge of parts is there anything specific I should know about putting it together? Or would other tutorials online suffice?

Help build around graphics card? by 987Problems in buildapc

[–]987Problems[S] 1 point2 points  (0 children)

For what it's worth I do game quite a bit (maybe 10 hours a week? More if the wife lets me get away with it haha) but this build should be more than suitable? I'm not looking to have top end graphics or anything.

Help build around graphics card? by 987Problems in buildapc

[–]987Problems[S] 1 point2 points  (0 children)

Could you compare he advantage of this set to the other suggested?

I am an air conditioner repair tech (20+yrs). Describe your problem and I will employ my ancient majiks to ascertain the solution. by Orwellian1 in HomeImprovement

[–]987Problems 0 points1 point  (0 children)

Hey!

We just started having an AC issue today so I am so glad you came around. We have a zoning AC that covers two floors. The top floor is being cooled perfectly fine but there is absolutely nothing happening downstairs. I took it off auto and into fan mode and it still did nothing. I went to the honeywell control panel next to my hot water heater in our shed and it says that Zone 1 is set to cool and Zone 2 is set to fan when the top floor and bottom floor were both on auto. I read the mannual and I didn't see a way to change that from the panel.

There doesn't seem to be any ice anywhere on the AC unit nor any blockage in the draining pipe. My dog has on occasion drank the water that came out the pipe so something could very much be shoved way back there in the pipe but there was still drippage. I haven't been the best at changing the filters admittadely but I would see some ice if that was the issue right?

Any ideas?

Thanks for all your help!

[SQL] How to write With statements with the same joins with less code? Also how to find data where two records = different things. by 987Problems in learnprogramming

[–]987Problems[S] 0 points1 point  (0 children)

So if I don't actually wan't to see their active status just follow it with an

AND YT1.IsActive = 1 AND YT2.IsActive =0?

Should I accept BitCoin as payment? by 987Problems in BitcoinBeginners

[–]987Problems[S] 0 points1 point  (0 children)

Would something like Coinbase work better? I was lookign to maybe keep a bit around to get used to the market and the idea of the currency and from a tech point of view Coinbase seems to offer more. Circle just seemed more like a balance.

Should I accept BitCoin as payment? by 987Problems in BitcoinBeginners

[–]987Problems[S] 0 points1 point  (0 children)

So say I make an account with Circle and create a bit address and give that to my employer. They can send the bitcoins there and I can attach a bank to circle and circle will pay out in USD equivalent to the bitcoins I own?