- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
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.
Admin
<blasphemy>
Mother of bloody god!
</blasphemy>
Who the hell are these people? They must die!
Admin
Matthew: Haha, good one!
You could also have:
SQL Server T-SQL Compilation Warning TS402: What the hell are you thinking?
Admin
SQL Server T-SQL Compilation Warning TS402: You are dangerously close to being published on thedailywtf.com
:))))
Admin
SQL Server T-SQL Compilation Warning TS402: WTF???
Admin
SQL Server T-SQL Compilation Warning TS402: Move away from the computer and no one will get hurt.
Admin
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)
Admin
Wow. Just wow.
I don't dare look at that again for fear of my brain exploding. This is a form of mental terrorism. :-(
Admin
The structure of the database is wrong but there is nothing wrong with variable reuse.
Admin
These last two posts are just jaw-droppingly unreal.
Much sympathy to the author. I forsee some rather long days and sleepless nights ahead...
Admin
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.
Admin
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...
Admin
SQL Server T-SQL Compilation Warning ID-10T: Selfdestruct sequence initiated. 20 seconds left until selfdestruction! Please leave the building!
Admin
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 :)
Admin
Please kill the people who did that. Or at least try and make them not to procreate. Please.
Admin
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 :-) )
Admin
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....
Admin
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.
Admin
LOL! Databas obfuscator, HUAHUAHUAHUA! That's exactly what it is. Just like we are starting to conclude, this guy is a misunderstood genius.
Admin
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!
Admin
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?
Admin
Man thats horrible. I think my eyes are melting, and my hair is on fire.
Admin
SQL Server T-SQL Compilation Warning TS402: Have you ever noticed that when you sit down at the computer, some idiot starts typing?
;-D
Admin
It appears that the person that generated the DB and the query was better at typing than coding.
Admin
OMG - and I thought I had some nasty SQL statement.
Admin
Have you considered quitting?
Admin
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?
Admin
Good Lord!!!
Run Away! Run Away!
Admin
"...CnAdrPrf.CnAdrPrf_ContryLongDscription as strCountry..."
Good job the 'developer' abbreviated country and description, otherwise the queries would be too long to understand. ;-)
Admin
I've always said there should be a licensing requirement in order to touch a database, and this is why.
Admin
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.
Admin
Hey Ralph, have you considered getting an RSS reader that isn't broken? Sounds a lot easier than changing entire websites.
Admin
That's hot
Admin
Make sure you have the latest version of RSS Bandit. I use it and I always see the the images!!! - http://www.rssbandit.org/
Admin
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!
Admin
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.
Admin
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.
Admin
Thanks for sharing. Looks like i'll die laughing
Admin
SQL Server T-SQL Compilation Warning TS402: Betcha can't say that five times fast
Admin
Who wrote this query and when was he executed?
Admin
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.
:)
Admin
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.
Admin
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.
Admin
Good.. GOD.
I wonder if I should link my old relational database instructor to this.
...Then again, he'd kill me :(
Admin
Should be " Please do not leave the building!".
NonDev
Admin
uhm....
this is a workaround surely ?
for the "too many linebreaks" error you get
Admin
I swear not only did that query make me cry but the vein on my forehead just bursted! >:(
Admin
Found this site by accident and I'm reading every post in chronological order (yeah, I know, WTF!).
The posts are great, but the comments are fantastic.
BTW, I don't see anything wrong with the DB schema / query :p
Admin
How's that looking, almost 16 years later? I ask because as a young professional, I've just been exposed to this kind of .... stuff for the first time, and it's only my second job.