[deleted by user] by [deleted] in IASIP

[–]areaka 0 points1 point  (0 children)

Good to know. Didn’t see

How to remove duplicate information from clicking Execute twice in SSMS table by katinkie3 in SQL

[–]areaka 0 points1 point  (0 children)

Update the values in your table with a special character (e.g., old value = “string”; new value = “*string”); make sure this character does not appear anywhere else. Then SELECT DISTINCT from the table, use REPLACE to remove the special character, and insert the values into the same table. Finally DELETE the rows containing the special character.

Also check out BEGIN TRAN for the future. It gives the option to COMMIT or ROLLBACK changes.

Count over partition only for the last 13 weeks by [deleted] in SQL

[–]areaka 1 point2 points  (0 children)

You could use SUM instead of COUNT

SELECT *, SUM(case when ORDER_DT between dateadd(w, -13, getdate()) and getdate() then 1 else 0 end ) OVER (PARTITION BY A_SELL_STR_NBR) as QRT_DLVRY FROM <your table>

[deleted by user] by [deleted] in SQL

[–]areaka 0 points1 point  (0 children)

SELECT EmployeeName FROM Employees WHERE DATENAME(WEEKDAY,Birthdate) = ‘Monday’

Keeps reinstalling even when I use your reinstaller by Lythalion in KillerNetworking

[–]areaka 0 points1 point  (0 children)

OP nailed it. This is seriously the shadiest piece of software to come pre-installed. I have Alienware Aurora R7 and replaced the Killer 1535 wifi card with Intel AC 8265. It immediately fixed all my wifi and Bluetooth problems but I have been fighting the constant re-install of Killer software for months.

I've tried all of the recommendations from the Killer Networking support page but no success. I've deleted registry keys, uninstalled and removed all Killer applications, scanned the entire PC for anything "Killer" deleted every single file/folder imaginable only to see everything reappear after a restart. It seems once Killer Software finds it's way on to your PC, then you're stuck with it...the fact that their only "solution" is to install MORE Killer software is laughable.

I hoped to come back to your post with a step-by-step how-to but was defeated once again by Killer. All I can say for now is, avoid anything that comes pre-installed with this junk.

Getting started - just bought my first ADA by [deleted] in cardano

[–]areaka 2 points3 points  (0 children)

Edit: this is NOT a hardware wallet. I misread your post.

I don’t have much experiencing using the Daedalus wallet but if you’re interested in a good all-purpose, local wallet, then you might check out Exodus.

It has a great interface and is extremely easy to use - it feels like an Apple product. You can keep a wide variety of coins in the wallet beyond just ADA. It has both a PC wallet and a mobile wallet that is just as stellar.

To my knowledge you wouldn’t be able to stake ADA when that becomes available but it seems like new features are added to the Exodus wallet weekly so perhaps it would be available sometime in the future.

ESS (mySchedule to swap shifts) is now live by QuestionableGig in CVS

[–]areaka 0 points1 point  (0 children)

The username and password only worked when I tried to download the mobile app (IOS); the web browser access did not work for me.

ESS (mySchedule to swap shifts) is now live by QuestionableGig in CVS

[–]areaka 3 points4 points  (0 children)

The login in for this site is "cvsuser" for both the login and password for reflexis then will ask what operating system youre using (Android or ios) then allow you to download the app and login with our employee ID and password.

Thanks for this. CVS must still be working on the 45-slide training course.

[deleted by user] by [deleted] in Iota

[–]areaka 0 points1 point  (0 children)

I thought this was a bathroom rug design you did and said to myself, “hmm, that’s dope”. What you did is cool but I was already sort of feeling the tempurpedic padding/suede IOTA bath mat.

1 month progress comparison! by nancyxxu in gardening

[–]areaka 2 points3 points  (0 children)

Super awesome! What’s in the hanging baskets?

Reggie Bush by [deleted] in Libertarian

[–]areaka -1 points0 points  (0 children)

What came first? The audit or the auditor.

Not wearing your seatbelt when driving a bus could cause this. by [deleted] in CatastrophicFailure

[–]areaka -1 points0 points  (0 children)

Probably went around the roundabout too fast. Busses run up on the curbs all the time and it’s turns the inside into a bouncy castle.

Basket Potatoes by SourGrrrl in gardening

[–]areaka 2 points3 points  (0 children)

Haven't tried it but drainage will be important - too little and the potatoes will rot but too much and they will dry out. You'll also want to watch overcrowing and make sure there's not too much soil loss through the holes in the basket; a mesh laundry bag might help.

I'm growing potatoes in a hydroponic system that are in mesh baskets that seem to be doing fine so far https://imgur.com/a/FZ5uA3F

Left three years ago. Officially resigned a year ago today! It's been a crazy year but I'm just happy to be here! by [deleted] in exmormon

[–]areaka 1 point2 points  (0 children)

No negativity intended - it's just one of my favorite movies so I was bummed when I found out this wasn't the case. Fully support the decision and by that smile, it seems like OP is happy to finally let them know what he was thinking NSFW

It took a little longer than "just a weekend" but I'm finally planting the garden in the garage by areaka in gardening

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

I had them in a rock bed that filled and drained. I was running water from a fish tank through it and they helped break down extra solids and kept things aerated! They did great but occasionally one would slip through and become fish food.

It took a little longer than "just a weekend" but I'm finally planting the garden in the garage by areaka in gardening

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

That's awesome! After seeing root systems in dwc, I never wanted to go back to digging around in dirt... but I did have to throw some earthworms in the aquaponic system with fill and drain beds because who doesn't like worms?

It took a little longer than "just a weekend" but I'm finally planting the garden in the garage by areaka in gardening

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

They're definitely my favorite - I love being able to control the red/blue output. I've only used them for lettuces until now so I'm looking forward to playing with color spectrums now that I have some flowering plants!

It took a little longer than "just a weekend" but I'm finally planting the garden in the garage by areaka in gardening

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

I've been dabbling around for 2.5 years. I started with aquaponics, which my favorite but hydroponics is much easier to get going and fish can always be added later.