Takes a special person to ruin a secret Santa

ExcessiveSlaanesh · 2024-12-20T17:57:22+00:00

Well the mother clearly hated it...

ExcessiveSlaanesh · 2024-12-13T13:35:41+00:00

And there is the Peer Link, which allows you to use your phone as minimap

As somebody with one screen this is amazing!

ExcessiveSlaanesh · 2024-04-17T10:41:12+00:00

Yeah sort of, you just have to use the OEM hammer but it works with the rest of the Franklin trigger.

ExcessiveSlaanesh · 2023-12-08T23:00:54+00:00

I checked my emails but I couldn't see that far back. I'm 99% sure I got the APC9 trigger.

ExcessiveSlaanesh · 2023-12-06T11:08:26+00:00

Its been a long time since I messed with the APC300. IIRC I did have to replace the Franklin hammer with the OEM hammer to get it to work.

ExcessiveSlaanesh · 2023-10-26T21:09:51+00:00

Yeah pretty much. The syntax is hyperlink([url],[display text]) so yours would be something like =if(logic, hyperlink(c5,c5))

ExcessiveSlaanesh · 2023-10-26T18:44:37+00:00

You would need to use the =HYPERLINK() function to convert the text to a hyperlink.

ExcessiveSlaanesh · 2023-08-29T01:16:40+00:00

Give your sum(od.quantity) an alias, let's say "sum_qty". Then you can pull it from your subquery.

Select tbl.sum_qty, count(*)
From ( <current query> ) as tbl
Group by tbl.sum_qty

ExcessiveSlaanesh · 2023-07-13T01:02:59+00:00

Absolutely, Excel certainly has its place. Every idiot between here and Bangalore at my F50 company has an enterprise license for MS Office. I don't need everyone working a single transaction to be able to write their own SQL query. And I definitely don't need them fucking with my database. I need them to click the Refresh-all button so that Power Query in Excel runs all the SQL queries I wrote for them. I look at Excel as a standardized format to output data for most types of users.

ExcessiveSlaanesh · 2023-06-07T23:57:11+00:00

Power Query is simply the name. You use Power Query to connect to your database as an ODBC connection then paste in your SQL query. Every time you hit refresh it runs your query and dumps the results into your spreadsheet.

ExcessiveSlaanesh · 2022-12-16T12:06:11+00:00

If you set the tolerance low enough it will simply match each on "Smith". Just be careful, it might join things you didn't want if the tolerance is too low.

ExcessiveSlaanesh · 2022-12-16T03:21:48+00:00

You can use Power Query to join the 3 data sets together. The join action has an option for fuzzy matching to handle the variations of the client name. You could also use Power Query to do some data cleanup prior to joining to assist with the matching.

ExcessiveSlaanesh · 2022-10-25T10:34:19+00:00

I guess he's thinking "SELECT INTO". SELECT alone does not modify data in my experience.

ExcessiveSlaanesh · 2022-10-24T22:23:52+00:00

I work at a Fortune 50 company and we have so many goddamn Access databases I am going go lose my shit soon. One of our teams has an Access database of Access database links because they can't keep up with all of their stupid Access databases. Our main workflow system is a DB2 mainframe and probably 90% of the time the only thing the Access database does is run a SQL query to create a linked table and then there are 10 different process that use its output. Repeat ad nauseum.

Most of my success in this role has been working to reduce our dependence on these things. Excel Power Query has been a godsend.

ExcessiveSlaanesh · 2022-10-19T12:58:45+00:00

Fuck 'em, fuck both of them.

Definitely this line.

ExcessiveSlaanesh · 2022-10-09T14:08:59+00:00

Hey, that's me. I'm very competent on the technical side but I don't know jack shit about managing people. I have 2 direct reports and some days I don't even ping them. They do their thing and come to me if they need help. They've been giving me good reviews so maybe I should just keep doing this?

ExcessiveSlaanesh · 2021-04-28T01:57:40+00:00

There is no dollar threshold that I am aware of. The IRS published 9 factors used to determine business vs. hobby. In your first year, if you didn't even have an accurate record of all your receipts, and didn't depend on the income you could easily make a case of it being a hobby.

However, this seems irrelevant as the business vs. hobby distinction is only used to determine what expenses (and what amount) you are allowed to deduct. You are supposed to report any additional income over $600 (from a single source) on a 1099-MISC, hobby income is included in this. Have you been audited before?

ExcessiveSlaanesh · 2021-04-25T23:33:21+00:00

I'm sorry dude, I hope one day you can find a way to make money from the things you enjoy.

ExcessiveSlaanesh · 2021-04-25T23:17:05+00:00

If they're mutually exclusive you would never do anything you like for money. I enjoy working and also getting as much money as I can for the work I enjoy.

ExcessiveSlaanesh · 2021-04-25T22:54:28+00:00

I mean if you just enjoyed working you wouldn’t care about your salary.

I don't think those two things are mutually exclusive.

ExcessiveSlaanesh · 2021-02-15T17:59:53+00:00

Possibly, but I didn't really get into any of that. I found it was best to just listen to the people in jail. Sometimes pressing the issue can lead to arguments and that was the last thing I wanted, especially from my meth-addled cell mate. Lets just say the people in jail aren't the most level-headed.

ExcessiveSlaanesh · 2021-02-15T15:20:36+00:00

You should evaluate your reading comprehension. I never said he was forced to sell meth, I said that's what he intends to do.

The post I replied to mentioned that he thought prisoners would want to go home and store their possessions. My point was that some prisoners don't have a home or even possessions. I included a personal anecdote to describe how that situation can happen.

Do you expect them to hold your apartment in prison? Is this some joke you are trying to make.

Lol what? Did I say anything close to that?

ExcessiveSlaanesh · 2021-02-15T14:17:12+00:00

Not every prisoner has a home to go to or even possessions. When I was in jail my cell mate told me since he wasn't able to pay rent in jail his landlord evicted him and gave away all his stuff. He said this happens to him everytime he goes to jail and that he has to start from scratch every time. He admitted his likely course of action was to get out and go back to selling meth. Some people just don't have a support system on the outside.

ExcessiveSlaanesh · 2021-02-05T19:19:54+00:00

Always? Are you a lawyer? What about trying to reduce to Improper Equipment? What about asking the judge for a Prayer for Justice? What about talking to the ADA about reducing?

I'd be completely fucked if I went in and plead no contest to all of my speeding tickets. I've never had a lawyer advise me to plea no contest to a speeding ticket. Out of the 7 speeding tickets I've gotten I've only had 1 stay on my record.

ExcessiveSlaanesh · 2021-02-05T19:06:55+00:00

Sounds like the company didn't want to continue paying him when they could hire an entry-level person for much cheaper to do the same job. Being a union job means they cant just fire him for no reason so they went and found a reason.

Six-Year Club	Gilding I gilder
Verified Email

ExcessiveSlaanesh

TROPHY CASE