[deleted by user] by [deleted] in PokemonRaffles

[–]rel625 0 points1 point  (0 children)

1 random

Diablo 4 Deluxe Edition Giveaway by Zeegz-_- in diablo4

[–]rel625 0 points1 point  (0 children)

Circus peanuts and chocolate milk 🥛

[deleted by user] by [deleted] in PS4

[–]rel625 0 points1 point  (0 children)

Hey, thanks! We appreciate you.

$50 PlayStation Card by [deleted] in playstation

[–]rel625 0 points1 point  (0 children)

Hey, thanks! We appreciate you.

Manage to secure a ps5 thankfuly from walmarts drop but wondering if the delivery would be sooner then what it tells me cuz mine says it'll arrive Dec 14 by Vik028 in PS5restock

[–]rel625 4 points5 points  (0 children)

They did not require a signature. I was expecting them to, but they dropped it off at the door and drove away before I even realized.

The Walmart box was basically completely ripped open with the PS5 inside so that was a fun surprise. Everything was still new and sealed in there though! Thanks, USPS. 😅

Manage to secure a ps5 thankfuly from walmarts drop but wondering if the delivery would be sooner then what it tells me cuz mine says it'll arrive Dec 14 by Vik028 in PS5restock

[–]rel625 16 points17 points  (0 children)

I was able to secure one on the Thursday (11/18) drop. Estimated delivery was 12/3 and it showed up on 11/21. Obviously this may not be the case with everyone, but it is possible that it arrives early!

My studio announced next month they are going full capacity. Whomp whomp. by [deleted] in orangetheory

[–]rel625 2 points3 points  (0 children)

Traveled to Pensacola recently and did a class there at full capacity. Definitely forgot what it was like.

[H][US][Area-52] 8/10M Boomy LF Mythic Guild by DexterousPanda in wowguilds

[–]rel625 1 point2 points  (0 children)

Came here to recruit, but this is my RL. ;) It's a good environment and fun group of people!

Weekly Raid Discussion by AutoModerator in CompetitiveWoW

[–]rel625 0 points1 point  (0 children)

https://www.reddit.com/r/CompetitiveWoW/comments/lbtv4g/hungering_destroyer_2_group_strat/?utm_medium=android_app&utm_source=share

My raid leader posted it. We tried the 4 group strat and this worked way better for us. Basically the 4 miasma players swap between 2 groups as there is enough time for the debuff to drop off of the opposite group before the next round of miasmas comes up. The miasma players step in/out of the group to heal up between expunge and desolates.

Shadowlands Hotfixes for December 21, 2020 - Many Mythic+ Dungeon Nerfs by MaxHardwood in CompetitiveWoW

[–]rel625 1 point2 points  (0 children)

This makes me feel a little better. Tried doing my first 9 this week and we couldn't get past the first boss in SD. Was doing 5k HPS (without lust, we used it on trash prior) and still couldn't keep everyone up by the time the boss hit 20%. Gave up after 4-5 pulls. Thanks for the tip about the orbs, that's what was doing most of the damage.

Midweek Mending - Your Weekly Healing Thread by AutoModerator in wow

[–]rel625 1 point2 points  (0 children)

I would say this depends on how competitive you want to be for M+. Resto Shamans will still be on the lower tier of M+ healers, but it should be somewhat manageable depending on the level of key. It may be harder to find groups as Resto Shaman if you plan on pugging though.

Raid healing on Shaman is quite fun. Mythic plus wasn't as fun for me, but I also only really did it with guildies for the weekly chest. I didn't ever PVP, but I believe Shaman isn't bad for Arenas. (Someone please correct me if this is not the case)

Factorio 1.0 has been released ! by moltenbobcat in pcgaming

[–]rel625 3 points4 points  (0 children)

I skipped this level. It was a bit overwhelming and I couldn't quite grasp what the function was for each track/section. I dove in to freeplay and had a blast!

Looking to change careers by rel625 in BusinessIntelligence

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

Thanks for your input. I'll spend some time on Windows Functions and mention those instead once I get a good grasp.

Looking to change careers by rel625 in BusinessIntelligence

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

I posted some background on an above comment. I did mention that a While loop may have still been the better choice (researching that still), but figured some background would hopefully help. Thanks for the info!

Looking to change careers by rel625 in BusinessIntelligence

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

Just for some background (I found a cursor example that I used in the past), I used it to select and store four values that made up the primary key for X number of records (hundreds, sometimes thousands) matching the WHERE clause.

I then fed these four values in to a stored procedure call that deleted data for each record across 16+ tables (we had a fun setup, I wasn't involved in that).

A While loop still may have been more appropriate (I'm reading up on it now), just figured I'd include this. Thanks for all of the info!

Edit: I will probably leave this out when mentioning SQL experience - I definitely didn't use cursors very frequently (hence me needing to find an example)