What is the newest installment of 'Random Thoughts' on Physics Forums?

[fresh_42]

After that, you could generate a slogan for it.
https://www.thesurrealist.co.uk/slogan.cgi

I like that one. It generated:
Semper Mathematician!

 

[WWGD]

After that, you could generate a slogan for it.
https://www.thesurrealist.co.uk/slogan.cgi

Maybe we can make a site with those 2 and the Deepak/Sixpack Chopra random quote generator

..And we need to find a place for this one too:

http://beesbeesbees.com/

 

[WWGD]

In my email:

" Hi, I would like to let you know about our fast cash service plan".

Me:

" I prefer to know about your unsubscribe me for good plan instead"

Unsuscribe is given as an option but you need to enter your email address; I suspect for them to confirm it is a real, active address.

 

[fresh_42]

And I thought you would have answered:
"I prefer cash that is slow and stays with me."

 

[WWGD]

And I thought you would have answered:
"I prefer cash that is slow and stays with me."

What's wrong with a 1% * rate ?

*Hourly rate.

 

[WWGD]

I finally figured out the query for the state with the most invoices short version: 5 lines instead of 13. No Over() nor partition.
... 2 years after the interview.

 

[collinsmark]

Whenever I'm stuck having to use a pen other than a Pilot G-2 I cry a little, inside.

 

[WWGD]

Whenever I'm stuck having to use a pen other than a Pilot G-2 I cry a little inside.

Im lucky if a pen lasts me for more than a few days before either fully drying out or having ink all over me when I pick them out.

 

[Ibix]

I finally figured out the query for the state with the most invoices short version: 5 lines instead of 13. No Over() nor partition.
... 2 years after the interview.

How does it handle the case where multiple states tie for maximum number of invoices?

 

[WWGD]

How does it handle the case where multiple states tie for maximum number of invoices?

I'll tell you in 2021? Good point. Let me get on my PC , harder to write from my phone. You may be right; I may need some t-sql like cubing, rollup , etc. to take care of that.

 

[Ibix]

Well - first note that it's a question you need to turn back on the questioner: how do I want it to be handled? Can I handle multiple responses, do I want just one and if so which one, or do I want an error?

 

[WWGD]

Well - first note that it's a question you need to turn back on the questioner: how do I want it to be handled? Can I handle multiple responses, do I want just one and if so which one, or do I want an error?

The idea, as I remember, was to show all records that qualify. So maybe we can use a "With Ties" here I would say. But need to double-check on this last.

 

[WWGD]

How does it handle the case where multiple states tie for maximum number of invoices?

Not sure, but in the AP Database , using tables Vendors, Invoices, this gave me the triplet

Well - first note that it's a question you need to turn back on the questioner: how do I want it to be handled? Can I handle multiple responses, do I want just one and if so which one, or do I want an error?

Here is the general 1 with all that qualify (delete the 'Top 1 with Ties' to have just 1 value )

SELECT TOP 1 WITH TIES Count(InvoiceID) Most , VendorState
FROM Vendors V JOIN Invoices I
ON V.VendorID=I.VendorID
GROUP BY VendorState
ORDER BY Most ASC

I guess we could add conditions but I haven't. Seems way advanced to have anything else.

EDIT: Somewhere where I worked someone was shocked when they found out I was saving these , other tables (Using CREATE table, etc) , querying against them and then dropping them. Same as a CTE but I just hated CTEs.

 

[WWGD]

And they accepted my method to delete duplicate although with a raised eyebrow:
Export to Excel, use Excel to delete, import back into SQL Server.
EDIT: But I am looking for one way to do it strictly within MSSMS.
I know how to find the duplicates, but working on a way of deleting them.

 

[fresh_42]

And they accepted my method to delete duplicate although with a raised eyebrow:
Export to Excel, use Excel to delete, import back into SQL Server.
EDIT: But I am looking for one way to do it strictly within MSSMS.
I know how to find the duplicates, but working on a way of deleting them.

Today is crazy data day here! Google localized me in a town I only have been once more than 10 years ago and which is not around the corner. And facebook wants to know how I found Tampa International. @WWGD you aren't involved somehow?

And all flights between the two are 1 stop or 2 stop flights over Atlanta or JFK. Someone messed up the databases.

 

[WWGD]

Me? No, I was in a confusing conversation myself.
" The Greeks were fighting machines"
"Why, if machines can't fight back?"

 

[WWGD]

But maybe someone else SELECT(ED) you (Ha-Ha) in the wrong query.

 

[fresh_42]

But maybe someone else SELECT(ED) you (Ha-Ha) in the wrong query.

Don't know how Google confused my city, but facebook only confused that I didn't watch the game in the Stadion.

 

[WWGD]

Don't know how Google confused my city, but facebook only confused that I didn't watch the game in the Stadion.

How does anyone know what you watched and where you watched it? Not sure I get what you're telling me.

 

[fresh_42]

My only possible connection to Tampa was that the Super Bowl was there, and I watched it live, although on tv. Guess facebook thinks this wasn't possible in Germany and concluded I must had been in Tampa.

Correction: was in Miami, not Tampa.

 

[WWGD]

My only possible connection to Tampa was that the Super Bowl was there, and I watched it live, although on tv. Guess facebook thinks this wasn't possible in Germany and concluded I must had been in Tampa.

Correction: was in Miami, not Tampa.

Ask Sugar Hill, only he may know.

 

[fresh_42]

Ask Sugar Hill, only he may know.

I have a contact in Ft Lauderdale, watched the game in Miami, and fb asks me about Tampa. Gotta lock up which age I entered on fb ... all paths lead to FL.

 

[WWGD]

Another strange post elsewhere:
Professor x. 10 years of teaching experience.
How do you teach experience?
Or:
Can Kafka be a database?
I doubt it, he's been dead for almost 100 years and likely has no idea what a database is. Maybe he can think of soneone slowly turning into a database?

 

[fresh_42]

I wonder how Kafka reads in English. Not that he knew English.

 

[Ibix]

I know how to find the duplicates, but working on a way of deleting them.

Look up the ROW_NUMBER function.

 

[Ibix]

I wonder how Kafka reads in English.

Kafka-esque.

 

[WWGD]

Kafka-esque.

It is an interesting name for a product. Not even sure what it is/does.

 

[fresh_42]

Not even sure what it is/does.

Escort service?

 

[WWGD]

Escort service?

Kafka escort? I though it was a database , dbms or related.

 

[Ibix]

It is an interesting name for a product. Not even sure what it is/does.

If I understand right, it's a tool for managing data that comes from multiple sources and goes to multiple sources in unpredictable bursts. LinkedIn apparently developed it - obviously their data comes in little messages from millions of users whenever they feel like posting something and publish it to your friends or whoever. Apparently it's designed to smooth out "bursty" data to be friendly to network traffic and disk operations. It's "optimised for writing", which is apparently a reference to Kafka the author - hence the name.