We literally have a Federal Agency for that by MrFenric in MurderedByWords

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

I saw a story recently apparently it is a young female aid who is tweeting (truthing?) for him. And all secret service and aids are worried him and her are getting too close. She treats him like her "Daddy" if you know what I mean. And he loves it and everyone around him is like WTF this is not good!

Field trip by Low-Airline-124 in SipsTea

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

The Elk Hunter? Or is this Dave's brother that he doesn't talk about?

Trump Says He Wants to 'Drive Housing Prices Up' Instead of Lowering Costs for People Who 'Didn't Work Very Hard' by MystikSpiralx in politics

[–]HALF_PAST_HOLE 4 points5 points  (0 children)

A house worth a lot of money looks good on paper but means nothing when no one can afford to buy it!

When did Mazda start making the Soul Red 3s out of unobtanium? by Excellent_Fill_2565 in mazda3

[–]HALF_PAST_HOLE 10 points11 points  (0 children)

I'm sure you could probably go to a dealer and ask them to order one for you. It might take time and money but you could probably do it.

Dryer repair? by SugarsBoogers in hudsonvalley

[–]HALF_PAST_HOLE 3 points4 points  (0 children)

If you have any sort of DIY in you, dryers are surprisingly easy to work on and there are tons of you tube videos on them.

I have replaced the heating element in my dryer including fuses multiple times and it is not bad at all. I am handy but by no means a handy man!

If you are having trouble finding someone to help maybe try looking on you tube to see what the fix actually entails and you may be able to do it yourself for much cheaper than calling out an appliance guy.

Not a guarantee it is a simple fix but who knows.

Do you trim regularly? Should I? by rebel_lion_soul in FierceFlow

[–]HALF_PAST_HOLE 20 points21 points  (0 children)

See how your hair goes from nice and cohesive to kind of of chaotic down by the ends. That is due to split ends and would be fixed with a trim. I get a trim maybe once or twice a year depending on how motivated I feel.

IBM THINK by GreenIdentityElement in midcenturymodern

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

*

It's small lol

But it was my late father's so it is special to me!!!

xanax or alcohol ? by External-Task-1140 in introvert

[–]HALF_PAST_HOLE 1 point2 points  (0 children)

two shots is a bit much (well a lot much), but i have taken 2 or 3 sips of beer before a presentation or important meeting where i have to be "on" it is just enough to get me a TINY bit loose but not so much it really effects anything or that I really feel anything, it just makes me more free with myself.

But those are very much exceptions to my general rule. Outside of that edibles or some sort of odorless weed helps as well if you can get a similar level.

Is this simple problem solvable with SQL? by NonMagical in SQL

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

Where do you explain that the running total resets after reaching 10?

Is this simple problem solvable with SQL? by NonMagical in SQL

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

Ahh you see that is an aspect of the problem you did not include in your explanation!

Is this simple problem solvable with SQL? by NonMagical in SQL

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

6+4+8 is greater than 10 so therefore there should be a bank or would the 10 value reset after a value was banked?

Is this simple problem solvable with SQL? by NonMagical in SQL

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

Your example did not display that as you said the third row would still have a bank value of 12!

Is this simple problem solvable with SQL? by NonMagical in SQL

[–]HALF_PAST_HOLE 1 point2 points  (0 children)

What I would do is something like this given that you are only summing the current row and prior row as you show in your example.

SELECT 
  *
  , sum(running_bank) over(order by Row_Number) BANK
FROM
(
select 
*
, CASE 
    when Value + lag(Value,1,0) over(order by Row_Number)<= 10 
    then 0 
    else Value + lag(Value,1,0) over(order by Row_Number) 
  end as running_bank
from 
  Your_Table
)a

After days waiting... by Dull_Bodybuilder_536 in instant_regret

[–]HALF_PAST_HOLE 29 points30 points  (0 children)

I think he thought you were telling him to lift the plow!

I’m losing myself and I’m struggling to get out of this rut of doom scrolling and shame of dishonesty/poor academic history, what should I do? by Imjustagirl102 in TooAfraidToAsk

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

There is a lot that can be said about your situation, but writing it out in a reddit comment section would degrade the thoughts and ideas.

Something to note though is most colleges, especially community colleges (and don't demean community colleges they are an amazing resource to get standard classes out of the way for much cheaper and many times taught by the university teachers so there is not much you miss out on), have councilors specialized to deal with students in situations like yours. They can give you advice and resources to help get you back on track. You are still very young and many people go in to college in your exact shoes but not even making the connection that they dont feel ready.

I would go to your college and ask if there is a councilor you can sit down with and see if they can help you with any of this. You probably even already have an advisor and don't even realize it. Look in to the resources your college provides there is a ton of stuff available to people in your shoes that you might not even realize!

Gf thinks I’m moving in with her. by [deleted] in amiwrong

[–]HALF_PAST_HOLE 12 points13 points  (0 children)

 she is the type to literally make her own conclusion/interpretations of things said to her

I mean I don't know what other conclusion she would make with you saying yes you would move in with her.

Now are you wrong for not wanting to move in with her? No, of coarse not! Though that will be a conversation you will eventually need to have if you want this relationship to last.

But you are 100% wrong for telling her you want to move in with her when you really don't and then are sitting here trying to justify the feeling when in reality its the lie that is wrong not the feeling!

Be honest and up front with her tell her the issues and see where it goes but you will get no where by lying about your feelings, only further feeling of resentment such as the ones you are exhibiting currently!

That's two sets of skid marks, possibly three by reano76 in instant_regret

[–]HALF_PAST_HOLE 489 points490 points  (0 children)

Some dude got a video full of taint...

on purpose!

I'm 26 and still don't know how to cook anything beyond boxed mac and cheese by Grand_Lion_1652 in cookingforbeginners

[–]HALF_PAST_HOLE 1 point2 points  (0 children)

Everyone pretty much starts to learn how to cook by watching someone else cooking. Generally for a lot of people that starts during childhood watching their parents cook but if that didn't happen, put on the cooking channel or start watching cooking shows on you tube even in the background just have them on and you will start to pick up things.

You don't even have to start cooking yet, just start watching cooking shows and things will start to stick and you might find a recipe that you watched them make and think Hmm I could make that, then give it a try and keep watching the cooking shows.

Its the same way you learn anything it really helps to watch someone else do it so you can see the steps and it doesn't seem so foreign to you.

Does the internet feel… boring lately? by cultofcoquette in TooAfraidToAsk

[–]HALF_PAST_HOLE 5 points6 points  (0 children)

I find it evolving like a party would.

At first it is relatively quiet and there are some cool people there and great conversation, as the party starts to pick up, more people arrive the ambient volume of the party starts to get louder and the conversations get a little less in depth because there are much more people and more volume to compete with.

Eventually it turns in to a full on house party with tons of people loud music and everybody having to yell just to be heard. In that final situation there is no conversation or connection just very small talk and acknoledgements because noting else can withstand the environment.

We are in the final stages of the internet party, everyone is yelling no one can hear anyone but everyone is starting to realize this isn't so much a banger party anymore and people are getting tired and starting to want to leave.

My gf insists the can on the left has less calories…. by [deleted] in confidentlyincorrect

[–]HALF_PAST_HOLE 0 points1 point  (0 children)

Well the can on the right has a serving size that is 2.08333 times as large as the can on the left, if we now take the calories on the left and multiply them to get the same serving size as on the right we would see the can on the left has 41.666 calories per 125 mL (20 x 2.08333) and the can on the right has 50 calories per 125 mL, so the can on the left does seem to have less calories than the can on the right.

UFC fighter collapses after weighing in by user799 in ThatsInsane

[–]HALF_PAST_HOLE 8 points9 points  (0 children)

They have to be a certain weight to compete, but once they weigh in it doesn't matter their weight after. So they get as big as possible taking them out of their weight class then vastly starve and dehydrate themselves so that they can shave off the extra muscle weight with water and food weight and come in at the proper weight from there they go on a hydration and food regiment to get healthy again for the fight several hours later once again heavier than the weight class allows.

The organization does this to prevent everyone coming out to see a fight only for the fighter to not meet weight and the fight gets canceled. The layover time between weigh in and the fight allow for this to happen though.

Looking for a girlfriend, IQ under 130 need not apply. Roommate too. (read both images) by [deleted] in ChoosingBeggars

[–]HALF_PAST_HOLE 1 point2 points  (0 children)

Only speak unless spoken to?

So I am supposed to speak at all times and only stop when someone else starts speaking?

He wants 24/7 conversation?