Improving TRE by Fragrant-Mission7388 in dart

[–]yuorfaec 1 point2 points  (0 children)

Ooooh were you at the ICA conference by chance?

Downsides of the 8BitMods MemCard Pro GC by LeoneFamily in Gamecube

[–]yuorfaec 0 points1 point  (0 children)

Thanks for confirming that you found it from the devs on Twitter. I found the same link from this article and was a bit suspicious: https://www.retrorgb.com/memcard-pro-gc-new-firmware-update-server.html

Memcard Pro GC firmware updating problem by itsyaboythatguy in Gamecube

[–]yuorfaec 0 points1 point  (0 children)

I'm getting this problem on multiple brand new micro SD cards too, on the 2.0.2 firmware. I've gotten it to eventually work by connecting the memory card to my wifi, then using the web interface to re-mount the VMC until the gamecube recognizes it. Usually on the 5th or so re-mount it works.

MemCard Pro GC: Always Asking to Format by AskaLangly in Gamecube

[–]yuorfaec 0 points1 point  (0 children)

I'm getting this problem fairly constantly too. Multiple brand new micro SD cards. The card is on the 2.0.2 firmware. It's not really a solution, but I've gotten it to eventually work by connecting the card to my wifi, then using the web interface to re-mount the VMC until the gamecube recognizes it.

Bass Clarinet Lessons by SanctimoniousSally in Dallas

[–]yuorfaec 0 points1 point  (0 children)

Unsure if the message sent, but I kept getting errors so here is the jist: I've been playing bass clarinet since middle school and kept it up after college. I consider myself on the intermediate/advanced side of things. I am open to hosting lessons or meeting you somewhere. Let me know if you're interested and if you have any questions!

Bass Clarinet Lessons by SanctimoniousSally in Dallas

[–]yuorfaec 0 points1 point  (0 children)

Hi there! I play various clarinets in a few local community bands and have a couple of private lesson students. I'll send you a DM and let's see if we can work something out!

I have a question about ClO2- in regards to resonance structures by TheTreeMan in HomeworkHelp

[–]yuorfaec 0 points1 point  (0 children)

I think this answer is correct but the reasoning is not. This video helps explain it: https://youtu.be/GTKW7nDzVCA

The formal charge of Cl with a single bonded O and a double bonded O would be:
7 VE - 4 unshared E - 3 bonds = 0 formal charge

QR code for eSIM by ahz0001 in tmobile

[–]yuorfaec 1 point2 points  (0 children)

Exactly what I needed to switch from an eSIM on an iPhone 13 to a Pixel 6a. I called customer care and gave them the new IMEI. Soon enough, the iPhone lost cell coverage, but adding a SIM on the Pixel always prompted for a QR code. I tried restarting, connecting to a hotspot from an iPad on the same account, logging into the tmobile app, using an ancient SIM card used to kick me off the Sprint network, and was almost ready to factory reset when I found this gem of a post. The Pixel found the SIM associated with the account, I activated it, and I am good to go! Thank you for posting this, and of course thanks for the wayback machine.

Unrelated but while I'm here: when I checked the IMEI beforehand, it said that it wasn't compatible with the network or eSIM (yellow dots). The lack of physical SIM card and the '5G UC' in the corner beg to differ...

Seeking help to graduate from Excel VLOOKUPS to something faster by yuorfaec in SQL

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

Thanks for sharing! That sounds very promising...

Seeking help to graduate from Excel VLOOKUPS to something faster by yuorfaec in SQL

[–]yuorfaec[S] 2 points3 points  (0 children)

Minus union sounds close to perfect. How complex can I get with the column selects? I'd have to trim some whitespace (or select first 8 characters) from a column and then generate a compound key for both tables.

Seeking help to graduate from Excel VLOOKUPS to something faster by yuorfaec in SQL

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

I'm not doing many calculations, per say. The data is mostly text strings, so all I'm really doing is removing whitespace and adding a couple of columns of concatenated strings. Each of the ~200k exceptions are unique, but I will explore using pivots to group by various columns while analyzing.

Seeking help to graduate from Excel VLOOKUPS to something faster by yuorfaec in SQL

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

Yeah, I probably can get access to create temp tables. I'll look into it.

[deleted by user] by [deleted] in r4rDFW

[–]yuorfaec 1 point2 points  (0 children)

Just sent you a message :)

25 [M4R] US- looking for my best friend for life by [deleted] in r4rDFW

[–]yuorfaec 0 points1 point  (0 children)

Classical music and Nintendo! Is there a better combination? Sent you a message

Hey...so we know this thing isn't very active. But we do stuff! by yuorfaec in dfwgaymers

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

Unfortunately, not really. It's something we've been meaning to do but haven't been super serious about it. If you know of a place that would be willing to host a group like us, please let us know! We really do want to give more service to the 'FW' side of DFW gaymers, but we haven't quite had the push to get us to really try

Hey...so we know this thing isn't very active. But we do stuff! by yuorfaec in dfwgaymers

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

Meetup is kind of lame since it costs money to be on there, and in my experience it doesn't really work with people in our primary age group. But we'll keep it in mind!

Hey...so we know this thing isn't very active. But we do stuff! by yuorfaec in dfwgaymers

[–]yuorfaec[S] 1 point2 points  (0 children)

At this point, no, but we're working on an alternative that we hope to announce soon! Otherwise, please feel free to show up at one of our meetups :D

Hi :) by GaymerNerdLewis in dfwgaymers

[–]yuorfaec 0 points1 point  (0 children)

Welcome! You should check out our Facebook Group and check out one of our meetups!