• Matthew W. Jackson (unregistered)

    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.

  • The Wolf (unregistered)

    <blasphemy>
    Mother of bloody god!
    </blasphemy>

    Who the hell are these people? They must die!

  • The Wolf (unregistered)

    Matthew: Haha, good one!

    You could also have:

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

  • Drazen Dotlic (unregistered)

    SQL Server T-SQL Compilation Warning TS402: You are dangerously close to being published on thedailywtf.com

    :))))

  • Bruno Bord (unregistered)

    SQL Server T-SQL Compilation Warning TS402: WTF???

  • NielsW (unregistered)

    SQL Server T-SQL Compilation Warning TS402: Move away from the computer and no one will get hurt.

  • Sven (unregistered)

    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)

  • Ray S (unregistered)

    Wow. Just wow.

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

  • name (unregistered)

    The structure of the database is wrong but there is nothing wrong with variable reuse.

  • James (unregistered)

    These last two posts are just jaw-droppingly unreal.

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

  • Centaur (unregistered)

    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.

  • KoFFiE (unregistered)

    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...

  • Mario Goebbels (unregistered)

    SQL Server T-SQL Compilation Warning ID-10T: Selfdestruct sequence initiated. 20 seconds left until selfdestruction! Please leave the building!

  • Tony (unregistered)

    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 :)

  • dust-e (unregistered)

    Please kill the people who did that. Or at least try and make them not to procreate. Please.

  • Reinhard Brongers (unregistered)

    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 :-) )

  • Reinhard Brongers (unregistered)

    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....

  • Phil Scott (unregistered)

    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.

  • Sergio Pereira (unregistered)

    LOL! Databas obfuscator, HUAHUAHUAHUA! That's exactly what it is. Just like we are starting to conclude, this guy is a misunderstood genius.

  • Alex Papadimoulis (unregistered)

    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!

  • Whatever (unregistered)

    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?

  • Tim Cartwright (unregistered)

    Man thats horrible. I think my eyes are melting, and my hair is on fire.

  • Tim Cartwright (unregistered)

    SQL Server T-SQL Compilation Warning TS402: Have you ever noticed that when you sit down at the computer, some idiot starts typing?

    ;-D

  • Steve O (unregistered)

    It appears that the person that generated the DB and the query was better at typing than coding.

  • Tim Smith (unregistered)

    OMG - and I thought I had some nasty SQL statement.

  • DMiller (unregistered)

    Have you considered quitting?

  • Ralph (unregistered)

    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?

  • Galen (unregistered)

    Good Lord!!!

    Run Away! Run Away!

  • JonBoy (unregistered)


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

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

  • Decibel (unregistered)

    I've always said there should be a licensing requirement in order to touch a database, and this is why.

  • Phil Scott (unregistered)

    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.

  • Cecil (unregistered)

    Hey Ralph, have you considered getting an RSS reader that isn't broken? Sounds a lot easier than changing entire websites.

  • Ron (unregistered)

    That's hot

  • [email protected] (Hassan Voyeau) (unregistered)

    Make sure you have the latest version of RSS Bandit. I use it and I always see the the images!!! - http://www.rssbandit.org/

  • [email protected] (Hassan Voyeau) (unregistered)

    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!

  • Hassan Voyeau (unregistered)

    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.

  • Hassan Voyeau (unregistered)

    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.

  • Indie (unregistered)

    Thanks for sharing. Looks like i'll die laughing

  • Robert Sharp (unregistered)

    SQL Server T-SQL Compilation Warning TS402: Betcha can't say that five times fast

  • ML (unregistered)

    Who wrote this query and when was he executed?

  • Good Samaritan (unregistered)

    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.

    :)

  • init6 (unregistered)

    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.

  • bysza (unregistered)

    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.

  • Nexis (unregistered)

    Good.. GOD.

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

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

  • NonDev (unregistered) in reply to Mario Goebbels
    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


  • n00blar (unregistered) in reply to Matthew W. Jackson

    uhm....

    this is a workaround surely ?

    for the "too many linebreaks" error you get

  • Coward (unregistered)

    I swear not only did that query make me cry but the vein on my forehead just bursted! >:(

  • CalvinH (unregistered)

    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

  • Anon (unregistered) in reply to Sven

    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.

Leave a comment on “How To Query "Pointless Pointless Pointless Pointless Pointless Pointless Pointless"”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article