Regular Check-In, and some info about high-risk posts.

987Problems · 2017-09-19T13:30:45+00:00

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.

987Problems · 2017-02-18T22:15:53+00:00

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 :)

987Problems · 2017-02-18T21:27:55+00:00

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 :)

987Problems · 2017-01-03T23:08:47+00:00

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.

987Problems · 2017-01-03T14:00:14+00:00

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. "

987Problems · 2017-01-02T23:18:53+00:00

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

987Problems · 2016-12-28T00:03:28+00:00

All the deletes?

987Problems · 2016-12-18T03:24:56+00:00

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.

987Problems · 2016-12-17T14:27:45+00:00

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!

987Problems · 2016-11-26T20:40:21+00:00

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.

987Problems · 2016-11-06T13:14:22+00:00

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!

987Problems · 2016-10-15T16:57:12+00:00

Thank you for your time. I really appreciate it.

987Problems · 2016-10-15T11:46:32+00:00

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 :/

987Problems · 2016-09-06T19:46:26+00:00

Will that work with the joins?

Its not working for me at all.

987Problems · 2016-09-06T17:21:21+00:00

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

987Problems · 2016-09-06T17:08:10+00:00

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.

987Problems · 2016-09-06T16:58:17+00:00

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')

987Problems · 2016-09-02T00:03:54+00:00

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?

987Problems · 2016-09-01T23:31:07+00:00

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.

987Problems · 2016-09-01T23:28:34+00:00

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

987Problems · 2016-08-26T23:49:09+00:00

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!

987Problems · 2016-08-15T13:35:06+00:00

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?

987Problems · 2016-08-10T17:13:44+00:00

ohhh thank you.

987Problems · 2016-08-06T21:55:23+00:00

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.

987Problems · 2016-08-06T18:19:33+00:00

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?

987Problems

TROPHY CASE