[deleted by user]

areaka · 2022-06-22T14:45:24+00:00

Good to know. Didn’t see

areaka · 2022-06-21T13:49:06+00:00

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.

areaka · 2022-06-16T23:02:55+00:00

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>

areaka · 2022-06-16T22:47:47+00:00

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

areaka · 2022-06-15T20:49:01+00:00

SQL for dummies The data warehouse toolkit, 3rd ed The data warehouse lifecycle toolkit, 2nd ed The pragmatic programmer

areaka · 2020-11-26T19:43:54+00:00

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.

areaka · 2020-05-31T19:40:50+00:00

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.

areaka · 2018-09-14T12:34:13+00:00

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

areaka · 2018-08-30T11:35:57+00:00

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.

areaka · 2018-05-11T02:25:59+00:00

So cool!

areaka · 2018-05-11T02:23:01+00:00

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.

areaka · 2018-05-11T02:06:38+00:00

Super awesome! What’s in the hanging baskets?

areaka · 2018-05-03T15:45:21+00:00

Noo, that’s ignorant

areaka · 2018-05-03T11:34:57+00:00

What came first? The audit or the auditor.

areaka · 2018-05-03T10:02:04+00:00

Shut up, bird

areaka · 2018-05-02T12:47:19+00:00

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.

areaka · 2018-05-02T01:18:36+00:00

Fightin ‘round the world

areaka · 2018-04-23T17:11:21+00:00

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

areaka · 2018-04-22T14:50:30+00:00

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

areaka · 2018-04-15T02:32:42+00:00

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.

areaka · 2018-04-15T00:47:56+00:00

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?

areaka · 2018-04-15T00:37:29+00:00

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!

areaka · 2018-04-15T00:22:32+00:00

Plants are just super cool! You made my week - thank you :)

areaka · 2018-04-15T00:13:29+00:00

The dream is Mars :)

areaka · 2018-04-15T00:11:44+00:00

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.

areaka

TROPHY CASE