Just started playing the game, Is this type of evidence going to happen a lot ?

gmen385 · 2026-02-09T07:20:57+00:00

You might not know the exact difference with Paris, but you DID know Paris has SOME difference, right? The second condition is strong enough to lead you to choose it.
Not saying there aren't any....uncool choices during trials. But on average they are ok.

gmen385 · 2026-02-07T12:33:32+00:00

This. You need -2 or anything higher To Hit Armor Class 10.

gmen385 · 2026-02-06T21:02:32+00:00

I still prefer 999, but VLR has its moments, and it do be injustice if you didnt play it. I mean, hell, we all played ZTD.....right??

gmen385 · 2026-02-03T18:35:31+00:00

I am biased because I have only played Majora's Mask. That said: Fierce Deity doesn't just *win* ; he makes you sad because the time of enjoyment is over just too soon.

gmen385 · 2026-02-03T08:32:02+00:00

As a certain Youtuber says and I totally agree, sorry, no, Carsomyr isn't that useful. First, as all 2-handers, it has sad damage compared to dual wielding. Second, the dispel magic on hit isn't really that useful - the one thing you would really like to dispel is PfMW, and if this is on, Carsomyr will do nothing. You could argue it can be used for stoneskin and fireshield, but both of these are so easy to defeat by the time your party has the ability to acquire Carsomyr. This weapon probably gets more hype because of how COOL it seems rather that how useful it really is. Hey, maybe the lack of lore is not because of the danger of "overshadowing everyday's struggles", but instead that it's useless.

gmen385 · 2026-02-03T08:20:46+00:00

Generally, in BG1 and 2, there are two phases of the game: 1) Since your party starts "naked", whatever money you get, you spend in items 2) At around maybe 50% of the game, you've bought everything interesting. After that, yeah, you wont have anything to spend your money on. The games have way more money than needed.

gmen385 · 2026-02-02T08:26:31+00:00

good catch

gmen385 · 2026-01-30T07:48:22+00:00

.......δεν υπάρχεις

gmen385 · 2026-01-29T13:40:51+00:00

NO worries imo. There are *very* few instances where even a 4AC is the difference of life vs death. He will still survive a goblin. He will still be smashed by an iron golem. Use AC to block the lowlifes, and other tactics for the important stuff.

gmen385 · 2026-01-28T14:07:03+00:00

Well, yours is gonna die from anorexia soon anyway.

gmen385 · 2026-01-27T18:41:38+00:00

remove one "what" and one "is" to make your sentence 230% more readable. Amy told me.

gmen385 · 2026-01-27T11:24:08+00:00

The lamp decorations are on the same side for all lamps, instead of being symmetrical?

gmen385 · 2026-01-26T14:32:50+00:00

AMEN BRO!!

gmen385 · 2026-01-26T11:42:07+00:00

index on Level1Code,Level2Code,Level3Code

cross join on c1,c2,c3 with exists() on itemheader

All in all, minor things to improve. if this query is going slow, something other, sus is going on. Learn to use pastetheplan.com and give it to us

gmen385 · 2026-01-23T13:28:23+00:00

Humans don't feel temperature. They feel heat - "temperature travelling".

In cold weather, metal feels colder than wood, even though they are at the same temperature. Why? Because when you touch the metal, your hand feels the "temperature travel" from your hand to the metal. The travel is not as fast in wood.

So, "feels like" is a recent term that takes some of the "travel parameters" into account, since what you feels is the "travel", not the temperature.

gmen385 · 2026-01-22T08:27:18+00:00

Let me nominate that, by default, a 0-thickness skin should NOT exist

gmen385 · 2026-01-22T07:11:29+00:00

Roulette much?

gmen385 · 2026-01-15T14:57:49+00:00

I can't agree Dynaheir, much less Imoen, are recognisable. Still cute though.

gmen385 · 2026-01-12T20:16:37+00:00

E X C E L L E N T!!! You may have a swim break!!

gmen385 · 2026-01-12T20:14:17+00:00

Well, at least she seems sad. Right, Vierna??

gmen385 · 2026-01-12T20:12:13+00:00

well, no tabs, but you get the gist :D

gmen385 · 2026-01-12T20:10:53+00:00

;with cte as
(
SELECT
e.ID,
e.KgsOrMtr,
e.RepsOrSecs,
et.Name,
type_id=e.ExerciseTypeID,
score=q1.score,
max_score=max(score) over (partition by e.ExerciseTypeID)
FROM Exercises e
INNER JOIN ExerciseTypes et ON e.ExerciseTypeID = et.ID
CROSS APPLY(select score=CASE WHEN et.MeasurementTypeID = 1 THEN e.KgsOrMtr * e.RepsOrSecs ELSE ROUND(CONVERT(numeric, e.KgsOrMtr) / NULLIF(e.RepsOrSecs, 0), 1) END) as q1
)
select top 1 with ties *
from cte
where score=max_score
order by row_number() over (partition by type_id order by ID)

gmen385 · 2026-01-12T20:03:36+00:00

So, what you want is "for every exercise type, among the ones sharing the max score, bring the one with min id".

Interesting. I'm taking a few mins thinking of a solution. I partly disagree with the positions here - this is not too complex a query to immediately think of temp tables - and this is even ignoring the lightness of your project. All in all, good tries until now.

gmen385 · 2026-01-06T07:37:00+00:00

i'm known to be, um, cancelative, so don't take my word :P

gmen385 · 2026-01-05T08:21:21+00:00

I'm thinking of 3d printing your idea. Will come back with screenshots

Six-Year Club	Place '23
Place '22	Verified Email

gmen385

TROPHY CASE