Comment On How To Query "Pointless Pointless Pointless Pointless Pointless Pointless Pointless"

Jakeypoo updates us with some more details ... [expand full text]
« PrevPage 1Next »

re: How To Query "Pointless Pointless Pointless Pointless Pointless Pointless Pointless"

2004-08-12 01:58 • by Matthew W. Jackson
It's a shame that database server's don't issue nasty warnings when you do something stupid like most modern language compilers.

I'm picturing the following being returned in the recordset:

SQL Server T-SQL Compilation Warning TS402: Visit www.monster.com and look for a job not related to databases.

re: How To Query "Pointless Pointless Pointless Pointless Pointless Pointless Pointless"

2004-08-12 01:59 • by The Wolf
<blasphemy>
Mother of bloody god!
</blasphemy>

Who the hell are these people? They must die!

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-09-01 23:13 • by init6
I once used a PDP-11 assembler that printed out "Warning: Stupid place for a label." It was right, that was a stupid place to put a label.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-09-24 10:30 • by bysza
Some idiot probably came up with an idea that if we are programming computers, and computers deal with numbers, then column names should be in numbers too. :/
That's why about 30 tables have cols like 'Fxxxx' where x is a digit. Eg.: F1000, F1001, etc.
We had a very hard time programming this.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 02:01 • by The Wolf
Matthew: Haha, good one!

You could also have:

SQL Server T-SQL Compilation Warning TS402: What the hell are you thinking?

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 02:50 • by Drazen Dotlic
SQL Server T-SQL Compilation Warning TS402: You are dangerously close to being published on thedailywtf.com

:))))

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 03:34 • by Bruno Bord
SQL Server T-SQL Compilation Warning TS402: WTF???

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 03:54 • by NielsW
SQL Server T-SQL Compilation Warning TS402: Move away from the computer and no one will get hurt.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 04:03 • by Sven
No words for this one. As a young professional I hope I will not be exposed to this kind of .... stuff. I am stunned (I will go back to my cave now)

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 04:29 • by Ray S
Wow. Just wow.

I don't dare look at that again for fear of my brain exploding. This is a form of mental terrorism. :-(

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 04:35 • by name
The structure of the database is wrong but there is nothing wrong with variable reuse.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 04:39 • by James
These last two posts are just jaw-droppingly unreal.

Much sympathy to the author. I forsee some rather long days and sleepless nights ahead...

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 05:45 • by Centaur
What’s wrong with that join (other than “LEFT JOIN” should be “LEFT OUTER JOIN”)? That’s pretty common, to factor out some entities into separate tables and then reference their IDs from a main table.

Of course, this 1-to-1-to-…-to-1 relationship is not such a case.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 06:30 • by KoFFiE
I must say - I admire the guys who could come up with such things, if they were aware of what they created - but I think a carreer as standup comedian would have been better for them. I also suspect that he would have to be into SM in this case, no sane brain would ever produce such a thing.
And otherwise - well, maybe the death-penalty isn't such a bad idea...

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 07:19 • by Mario Goebbels
SQL Server T-SQL Compilation Warning ID-10T: Selfdestruct sequence initiated. 20 seconds left until selfdestruction! Please leave the building!

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 07:33 • by Tony
Looking at the Parenthesises I would think this was made to work in both Access and SQL Server. Either way WTF

All your tables belong to CN :)

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 07:37 • by dust-e
Please kill the people who did that. Or at least try and make them not to procreate. Please.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 07:59 • by Reinhard Brongers
It's probably Einsteinish: we don't understand what Albert was doing, but profit by the results. The person who was able to create this must have a brilliant brain. I salute him, I really do.
Jakeypoo, you should feel puny that you did not grasp this product of a clearly superior mind.
(And I am lucky that I don't have to cope with it :-) )

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 08:02 • by Reinhard Brongers
Now I get it: It is the ultimate expression of Customer RELATION Management and by building it this way, it actually models the difficult relations between people, countries, religions, etc. that exist in the real world. Again, you have to give this person credit for analysing that so very accurate....

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 08:28 • by Phil Scott
The more I think about it, the more it become clear. I'm willing to bet this is vendor provided software. The vendor, being very intelligent realized encrypting your views and sprocs is useless in SQL Server. So, they created a database obfuscator. That way, the only way to get updates and changes would be through the vendor. And you get the added benefit of the database being so screwed up, only a crazy person would try to use crystal to query the thing.

So there you go.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 08:46 • by Sergio Pereira
LOL! Databas obfuscator, HUAHUAHUAHUA! That's exactly what it is. Just like we are starting to conclude, this guy is a misunderstood genius.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 09:12 • by Alex Papadimoulis
Phil ... sadly, this is *not* vendor provided. This is custom website code developed for a client of our company (some school)! We (me *excluded*) have all sorts of ... erm ... uniquely innovate .... designs like this ... which is what gave me the inspiration to start up this blog!

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 09:23 • by Whatever
If it was for a client, this is probably what they asked for, and I'll bet they have a damn good reason for asking for it.

Do any of you bitches have the spec?

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 09:50 • by Tim Cartwright
Man thats horrible. I think my eyes are melting, and my hair is on fire.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 09:51 • by Tim Cartwright
SQL Server T-SQL Compilation Warning TS402: Have you ever noticed that when you sit down at the computer, some idiot starts typing?

;-D

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 10:02 • by Steve O
It appears that the person that generated the DB and the query was better at typing than coding.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 10:16 • by Tim Smith
OMG - and I thought I had some nasty SQL statement.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 10:47 • by DMiller
Have you considered quitting?

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 11:19 • by Ralph
When you post images on the site can you use the whole path http://www.dailywtf/images/... instead of /images/... when you try to read the blog using an RSS Reader like RSS Bandit and it displays as a broken image.

It's enough to make me say WTF?

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 12:27 • by Galen
Good Lord!!!

Run Away! Run Away!

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 12:58 • by JonBoy

"...CnAdrPrf.CnAdrPrf_ContryLongDscription as strCountry..."

Good job the 'developer' abbreviated country and description, otherwise the queries would be too long to understand. ;-)

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 13:14 • by Decibel
I've always said there should be a licensing requirement in order to touch a database, and this is why.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 13:30 • by Phil Scott
JonBoy: they probably should have used hungarian notation on the table names and column names to clear it up even more: tblCnAdrPrf.vc_nn_CnAdrPrf_ContryLongDscription as strCountry

that way I'd know that CnAdrPrf_ContryLongDscription is a non-null varchar, and I think we can all agree that vc_nn_CnAdrPrf_ContryLongDscription makes more sense.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 15:04 • by Cecil
Hey Ralph, have you considered getting an RSS reader that isn't broken? Sounds a lot easier than changing entire websites.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 16:00 • by Ron
That's hot

RE: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 16:24 • by hassan.voyeau@gmail.com (Hassan Voyeau)
Make sure you have the latest version of RSS Bandit. I use it and I always see the the images!!! - http://www.rssbandit.org/

RE: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 16:27 • by hassan.voyeau@gmail.com (Hassan Voyeau)
Also, one reason I like RSS Bandit, is that I can reply to posts on the Daily WTF and it even saves it in a Sent Items folder. Oh, and that SQL is a mess!

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 16:33 • by Hassan Voyeau
My bad, I just got the next post, RSS sucks. Did I mention that I just started using RSS Bandit and I never bothered to look at the properties of the image to this post before making my comment. You see, never assume, because you'll be making an ASS of of U and ME.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-12 16:37 • by Hassan Voyeau
Edit : RSS sucks should be RSS Bandit sucks. OK, this is my last comment to this post, hope Alex doesn't ban me from commenting.

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-13 04:19 • by Indie
Thanks for sharing. Looks like i'll die laughing

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-14 01:15 • by Robert Sharp
SQL Server T-SQL Compilation Warning TS402: Betcha can't say that five times fast

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-20 04:57 • by ML
Who wrote this query and when was he executed?

re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2004-08-23 06:01 • by Good Samaritan
Can't help you with the query or other code in this project but would just like to say life is worth living (after 5pm and w/ends).

Meanwhile I will continue my work for a people normaliser. Similar to DB normalisation process but applied with electric shocks and very strong chemicals. So far, created several forms of vegetables without any complaints from subjects nearest and dearest.

:)

Re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2006-05-22 04:15 • by Nexis
Good.. GOD.

I wonder if I should link my old relational database instructor to this. 

...Then again, he'd kill me :(

Re: re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2006-05-22 05:13 • by NonDev
73911 in reply to 23164
Anonymous:
SQL Server T-SQL Compilation Warning ID-10T: Selfdestruct sequence initiated. 20 seconds left until selfdestruction! Please leave the building!


Should be " Please do not leave the building!".

NonDev


Re: re: How To Query &quot;Pointless Pointless Pointless Pointless Pointless Pointless Pointless&quot;

2006-07-06 06:48 • by n00blar
80438 in reply to 23150

uhm....


this is a workaround surely ?


for the "too many linebreaks" error you get

Re: How To Query "Pointless Pointless Pointless Pointless Pointless Pointless Pointless"

2009-04-17 13:13 • by Coward (unregistered)
I swear not only did that query make me cry but the vein on my forehead just bursted! >:(

runescape gold

2011-05-05 23:47 • by runescape gold (unregistered)
« PrevPage 1Next »

Add Comment