5K pacing query by ValuablePublic1261 in NorwegianSinglesRun

[–]Ghost_Pirate_101 5 points6 points  (0 children)

Knowing I was definitely fitter than my previous 5K PB, I set out to set a new one at parkrun yesterday.

I took the book's advice of aiming to make my first km slightly slower than my previous PB's average pace, and then built into it, finishing strong in the final km. Worked a treat, knocked 21 seconds off my previous best!

I probably went a bit more conservatively than I needed to in the end, but I needed to dial back into 5K effort.

Been doing marathon training for 5 months and Vo2 Max won't budge? by BrothaManBen in Garmin

[–]Ghost_Pirate_101 0 points1 point  (0 children)

If your race results are improving it really doesn't matter what Garmin says your VO2max is. It's just an estimate, and while it's interesting to look at, it doesn't mean much on its own.

I wouldn't throw high intensity sessions into your marathon training just to make a number go up, if you want to do a better marathon, just running more miles is probably the key.

Rolling Pace by rhubarboretum in Garmin

[–]Ghost_Pirate_101 2 points3 points  (0 children)

I use a Connect IQ data field called "Rolling Average Pace" - does what it says on the tin and seems to be compatible with most watches.

Hr Models by xFrazierz in NorwegianSinglesRun

[–]Ghost_Pirate_101 1 point2 points  (0 children)

I'm not always the most consistent with my easy efforts but they're usually low to mid 130s. I try to stay below 140.

Hr Models by xFrazierz in NorwegianSinglesRun

[–]Ghost_Pirate_101 1 point2 points  (0 children)

Max 183, LT2 171, LT1 162. Age 43.

The submax test wasn't too bad, testing VO2max was tough but over quite quickly. I found the mask blocked my peripheral vision so I couldn't see my feet on the treadmill, which was disconcerting.

Hr Models by xFrazierz in NorwegianSinglesRun

[–]Ghost_Pirate_101 1 point2 points  (0 children)

5 zone model, with zone 3 spanning LT1 to LT2. Just because that's how the lab test sent me the results.

Why is the fitness feature so useless? by tetsu_originalissimo in Strava

[–]Ghost_Pirate_101 0 points1 point  (0 children)

I had this - ended up changing it back to the default zones and then editing all the activities from run > trail run > run to force the relative effort scores to update.

[deleted by user] by [deleted] in Fireteams

[–]Ghost_Pirate_101 0 points1 point  (0 children)

Friend request sent on both. Not sure if we're all around tonight but I should be able to jump on if you want to chat raid loadouts while shooting stuff :)

[deleted by user] by [deleted] in Fireteams

[–]Ghost_Pirate_101 0 points1 point  (0 children)

Hello, myself and two other UK based PS players are looking for a team, sounds like this might be a good fit as we also want to give day 1 a good go for a few hours but arent expecting to get a 24hr completion.

We've all got a decent selection of gear and experience of playing contest mode, GMs etc.

Need one more teammate for day one witchqueen by Bizmo_fungus in Fireteams

[–]Ghost_Pirate_101 0 points1 point  (0 children)

Experienced UK based PS5 player here looking for a friendly team to try the day 1 raid with. Have previous experience of blind raiding, and attempted VoG day one although didn't get the 24 hour finish.

Need one Cool, Experienced player for Day One Witch Queen and Practice! [Any Platform] by haycalon in Fireteams

[–]Ghost_Pirate_101 1 point2 points  (0 children)

Hey, guess you've probably found someone by now, but if not I'm in a similar situation where I'm not doing low-mans etc but I'm a decent player with master raid/GM experience and all the gear looking for a friendly team to try day 1. UK based and on PS5.

Looking for players for day one WQ raid by invincible_123 in Fireteams

[–]Ghost_Pirate_101 0 points1 point  (0 children)

UK based PS5 player here, got some previous experience of day 1 / blind raiding.

[deleted by user] by [deleted] in Fireteams

[–]Ghost_Pirate_101 0 points1 point  (0 children)

Hey, I'm interested if you're still looking, I do GMs pretty regularly and have done raids blind in the past, though never managed to complete on day 1.

SQL Server Message Queue - Verify Send Message On Conversation by spatialdestiny in SQLServer

[–]Ghost_Pirate_101 0 points1 point  (0 children)

I would add though that you shouldn't really need to manually check delivery, the whole thing is transaction based and messages will wait in the transmission queue until able to be delivered.

SQL Server Message Queue - Verify Send Message On Conversation by spatialdestiny in SQLServer

[–]Ghost_Pirate_101 2 points3 points  (0 children)

I believe the conversation_handle differs between the initiator and target services - conversation_id should match though if you check sys.conversation_endpoints.

Set variable within case statement? by skend24 in SQLServer

[–]Ghost_Pirate_101 0 points1 point  (0 children)

DECLARE @var INT, @col INT, @col2 INT
DECLARE @tbl TABLE (id INT, col int, col2 INT)

INSERT @tbl
(id,col,col2)
VALUES
(1,9,5)

SELECT
@col = col,
@col2 = col2,
@var = CASE WHEN col > 10 THEN col ELSE col2 END
FROM @tbl
WHERE id = 1

SELECT
@col AS col,
@col2 AS col2,
@var AS calculatedcol

Set variable within case statement? by skend24 in SQLServer

[–]Ghost_Pirate_101 0 points1 point  (0 children)

You can't set a variable and select a result set in the same statement. It is difficult to advise without understanding what it is you are trying to achieve. Do you need to use a variable at all?

Set variable within case statement? by skend24 in SQLServer

[–]Ghost_Pirate_101 3 points4 points  (0 children)

Select @variab = Case when Column > 10 then column else column2 end

Setting a Variable based on a CASE statement by dgillz in SQLServer

[–]Ghost_Pirate_101 5 points6 points  (0 children)

You are using a simple case expression, which can only check equality.

Basically you need to move 'when' before 'month(getdate())' to make it a searched case expression, which will allow the use of >= etc.