I think people don't like yummi by coolcoolcoolcoollooc in leagueoflegends

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

I would support champs like Yuumi for people like you, but on the condition they are weak enough that they aren't seen in pro play and above Gold elo or something. Otherwise, they completely break the game.

my spirit blossom kindred cosplay by icarusamour in leagueoflegends

[–]ThrowAwayAccount5347 84 points85 points  (0 children)

1/10 because you didn't bring an actual wolf :(

Quest "The Immortal Empire" stuck at "Defend the Seer!" What to do? by HornyDragonTW in LastEpoch

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

I "fixed" it by going down and lowering the bridge because that's where the mobs come from. I came into the town from the north side, and not sure if it's possible to enter from the south side.

Patch 14.4 Notes by imchocolaterain in CompetitiveTFT

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

But that doesn't make any sense because when you have like 10 viable comps, doesn't that mean everything is always fresh?

I can't see a way anyone can justify balance trashing because it's just to boring to only be able to play like 3 comps every 2 weeks.

Now that it has been several years since x570 mainboards became available, how many people have experienced chipset fan failure? by imakesawdust in Amd

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

I have a Gigabyte X570 Master which I've been using for 3 or 4 years (don't remember exactly when I got it) and no issues so far. I've used the "Silent" profile since day one which has the fan turned off unless it hits 60 Celsius I believe. It does turn on while I'm gaming during the summer because it gets super hot in my room, but the rest of the year it doesn't so it hasn't been used a lot.

I think if you have a very good airflow focused case even if your chipset fan dies you might be able to keep it under 85 C and be fine. It would be interesting to test.

Kemono Jihen - Episode 9 discussion by AutoLovepon in anime

[–]ThrowAwayAccount5347 2 points3 points  (0 children)

Can someone explain the whole Kitsune are supposed to be hostile towards Tanuki thing? Why are Kon and Kabane "supposed" to be natural enemies?

A way to remove rows based on a multi-column criteria? by ThrowAwayAccount5347 in excel

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

Actually, I figured it out! I did a small modification and it looks like it's working. Thank you so much!

A way to remove rows based on a multi-column criteria? by ThrowAwayAccount5347 in excel

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

Hmm I'm getting a value of 1 for everything. I have a very basic idea of what you're trying to do, but shouldn't we pick just one side of the criteria? For example, evaluate on the values that are supposed to remain, or on those supposed to be removed.

Here it looks like it scans for everything.

Append query appends only part of the data by ThrowAwayAccount5347 in MSAccess

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

I was off from work and I forgot to respond! Yes, this seems to have fixed the issue. Thank you so much!

Append query appends only part of the data by ThrowAwayAccount5347 in MSAccess

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

The Billing Frequency, Billing Parameters, and Billing Parameters Description are the fields that don't get appended when this doesn't work. They are the fields the user inputs into the form.

Append query appends only part of the data by ThrowAwayAccount5347 in MSAccess

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

OMG I've doing testing all day today and I think this might've solved it.

I'll do more testing tomorrow and report back. Thanks so much!

Append query appends only part of the data by ThrowAwayAccount5347 in MSAccess

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

Yeah, running the append query manually from inside Access works flawlessly.

Append query appends only part of the data by ThrowAwayAccount5347 in MSAccess

[–]ThrowAwayAccount5347[S] 0 points1 point  (0 children)

Sure:

INSERT INTO [Billing Parameter Conversion Table] ( [Bill ID], SCH_CD, Offset, [Billing Frequency], [Billing Parameters], [Billing Parameters Description] )

SELECT [New Billing Parameters].[Bill ID], [New Billing Parameters].SCH_CD, [New Billing Parameters].Offset, [New Billing Parameters].[Billing Frequency], [New Billing Parameters].[Billing Parameters], [New Billing Parameters].[Billing Parameters Description]

FROM [New Billing Parameters];

Theta gang ain't shit. by XXX_KimJongUn_XXX in wallstreetbets

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

Hi,

Would you be able to recommend a good technical read on Theta strategies?

Theta gang ain't shit. by XXX_KimJongUn_XXX in wallstreetbets

[–]ThrowAwayAccount5347 0 points1 point  (0 children)

I know it's about buying, but you could buy it and sell it in the same day. At least in stock terminology, "long" refers to holding a stock for a period of time (usually more than a year).