• (cs) in reply to BC

    Well, it's just a select, so I doubt that. Unless they have an evil trigger behind this, but I see no trace of that in this file. I'm also thinking that they didn't have the intelligence to have the idea to even use those...

  • (cs) in reply to BC
    BC:
    I don't get what this code is supposed to do. My best guess is that it tries to delete all of human history?
    Well, it's just a select, so I doubt that. Unless they have an evil trigger behind this, but I see no trace of that in this file. I'm also thinking that they didn't have the intelligence to have the idea to even use those...
  • phil232 (unregistered) in reply to esoterik
    esoterik:
    ObiWayneKenobi:
    ClaudeSuck.de:
    If you do you will have to take the responsibility when the business people notice that the results are different from what they were before. And if you tell them at that moment that YOU made this change I don't want to be in your shoes.

    Speaking from experience, it's more fun when the original report was outright wrong and performed incorrect calculations, and you're told to change the new one back to give bad results so it matches the old reports.

    That's so true, you can probably find 3 web-comics and a Dilbert with a similar joke!

    Before i started working here, someone found a bug in one of our calculations, they fixed it, but one of our biggest customers absolutely had to have the old calculation. Consistency of the measurement was more important, for their manufacturing, than a correct value; it would have taken far more work for them to re-calibrate their process, or figure out how to correct the old data, than to just use the (consistently) incorrect calculation.

    Another example why you shouldn't re-factor just for the beauty or the readability of the new code. There is more than just code involved.

  • blockem (unregistered) in reply to BC

    Its a big "but the system cant read "*"'s"

    Then oh, now ive found that "/"'s are a problem.

    etc etc.

    There are far more elegant ways to do it.

    In fact most people would put something like that into one function, CleanUpTheText().

    Then you only need to do it once.

    Mind you some languages could do a lot of that in a single line.

    but structures like that are common in old code where no one wants to fiddle with whats there and works, they just want to add the bit that fixes their issue.

    Can be a nightmare to pull them apart, sometimes they are in a special order for a reason, and you can cause major drama's in apps, especially older style apps where they did a lot of processing using text flags instead of setting status's in fields.

    That was because earlier versions of the databases had a limited number of fields, so it used to be smart to use things like binary flags in numbers or texts flags for multiple purposes.

  • bene (unregistered) in reply to BC

    Only the period AD, BC.

  • cyberwired (unregistered)

    how on earth do you comprehend that in order to write it all in the first place!?

    My reading it went like this "SELECT...right its a SQL query...must be a few of them...this doesn't end...must be some other language I don't know...scroll scroll scroll...ORDER BY...WAIT WTF!? scroll back up! FROM documents!? WHERE!! THATS ONE FRIGGIN SQL QUERY!!!!"

  • (cs)

    All the line breaks in the world wouldn't be able to add the clarity I need to be able to comprehend this... thing.

  • Tom (unregistered) in reply to BC

    Often the cause of this kind of antipattern is an environment where it's very hard to release actual code due to the amount of sign-off, formal testing, change control, etc etc required, so people sneak functionality in "under the hood" by adding it to config, where the controls are less rigorous.

  • Sock Puppet 1 (unregistered) in reply to TeaDrinker
    TeaDrinker:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Pope Pius X:
    98052:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Bert Glanstron:
    The Corrector:
    fake frits #17:
    ObiWayneKenobi:
    fake frits #17:
    frits:
    John Bobbit:
    Lockwood:
    Peter Johnson:
    Sock Puppets 1 and 2:
    Sock Puppet 3:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    That's funny, I thought I read this article yesterday.
    That's funny, I thought I read this comment earlier.
    My point is that they haven't published an article today.
    Then why do they call it the daily wtf?
    Good question. They have a very liberal interpretation of "daily".
    This is fun, can I play?
    No, I only have two hands.
    You have me.
    And my axe!
    Not this again...
    Who hasn't done something like this?
    I haven't.
    You have now!
    Oh, he'll.
    FTFY
    . Dear Remy,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on writing posts with sock puppets instead of posting an article clearly shows that you are too young and too stupid for unicorns.

    Go away and grow up.

    Sincerely, Bert Glanstron

    Don't say that, I love Remy!
    Me too! Especially his 'corns!
    I heard one of his posts was nominated for a Pulitzer!
    We're all just darned socks!
    I haven't been damned. Perhaps I haven't been used enough to become holy.
    FTFY
    It's all good fun until somebody gets the Pope involved.
    I guess there's more than one way to create a vertical sine wave that increases in amplitude...
    Like what, brain?
    Well an unconstrained positive feedback loop would do that for you.
    Day 3, and we're still struggling to produce a wtf.

  • Sock Puppet 2 (unregistered) in reply to Sock Puppet 1
    Sock Puppet 1:
    TeaDrinker:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Pope Pius X:
    98052:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Bert Glanstron:
    The Corrector:
    fake frits #17:
    ObiWayneKenobi:
    fake frits #17:
    frits:
    John Bobbit:
    Lockwood:
    Peter Johnson:
    Sock Puppets 1 and 2:
    Sock Puppet 3:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    That's funny, I thought I read this article yesterday.
    That's funny, I thought I read this comment earlier.
    My point is that they haven't published an article today.
    Then why do they call it the daily wtf?
    Good question. They have a very liberal interpretation of "daily".
    This is fun, can I play?
    No, I only have two hands.
    You have me.
    And my axe!
    Not this again...
    Who hasn't done something like this?
    I haven't.
    You have now!
    Oh, he'll.
    FTFY
    . Dear Remy,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on writing posts with sock puppets instead of posting an article clearly shows that you are too young and too stupid for unicorns.

    Go away and grow up.

    Sincerely, Bert Glanstron

    Don't say that, I love Remy!
    Me too! Especially his 'corns!
    I heard one of his posts was nominated for a Pulitzer!
    We're all just darned socks!
    I haven't been damned. Perhaps I haven't been used enough to become holy.
    FTFY
    It's all good fun until somebody gets the Pope involved.
    I guess there's more than one way to create a vertical sine wave that increases in amplitude...
    Like what, brain?
    Well an unconstrained positive feedback loop would do that for you.
    Day 3, and we're still struggling to produce a wtf.

    That is the wtf.

  • Bert Glanstron (unregistered) in reply to Sock Puppet 2
    Sock Puppet 2:
    Sock Puppet 1:
    TeaDrinker:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Pope Pius X:
    98052:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Bert Glanstron:
    The Corrector:
    fake frits #17:
    ObiWayneKenobi:
    fake frits #17:
    frits:
    John Bobbit:
    Lockwood:
    Peter Johnson:
    Sock Puppets 1 and 2:
    Sock Puppet 3:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    That's funny, I thought I read this article yesterday.
    That's funny, I thought I read this comment earlier.
    My point is that they haven't published an article today.
    Then why do they call it the daily wtf?
    Good question. They have a very liberal interpretation of "daily".
    This is fun, can I play?
    No, I only have two hands.
    You have me.
    And my axe!
    Not this again...
    Who hasn't done something like this?
    I haven't.
    You have now!
    Oh, he'll.
    FTFY
    . Dear Remy,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on writing posts with sock puppets instead of posting an article clearly shows that you are too young and too stupid for unicorns.

    Go away and grow up.

    Sincerely, Bert Glanstron

    Don't say that, I love Remy!
    Me too! Especially his 'corns!
    I heard one of his posts was nominated for a Pulitzer!
    We're all just darned socks!
    I haven't been damned. Perhaps I haven't been used enough to become holy.
    FTFY
    It's all good fun until somebody gets the Pope involved.
    I guess there's more than one way to create a vertical sine wave that increases in amplitude...
    Like what, brain?
    Well an unconstrained positive feedback loop would do that for you.
    Day 3, and we're still struggling to produce a wtf.

    That is the wtf.

    Dear Sock Puppets,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on playing in the comments clearly shows that you are too young and too stupid.

    Go away and grow up.

    Sincerely, Bert Glanstron

  • The Insider (unregistered) in reply to BC

    I think that from the moment you need to put comments on a query you HAVE to suspect something is going terribly WRONG

  • shanghai coder (unregistered)

    US ppl are kids, hahaha, want a lollypop, hahaha

  • Kennedy (unregistered) in reply to shanghai coder
    shanghai coder:
    Capt. Cavemerica:
    shanghai coder:
    Only thing better is that your mothers are bitches and f*ckable.

    Isn't that what the Japanese said about China during WWII?

    So what you american troll?

    If that isn't the troll calling the ogre green, I don't know what is.

    Besides, we know you're not in China because if you were, that "firewall" you mentioned would prevent you from visiting this site where people are free to express any opinions they want; including those that are not favorable toward certain communist regimes.

  • shanghai coder (unregistered) in reply to Kennedy
    Kennedy:
    Besides, we know you're not in China because if you were, that "firewall" you mentioned would prevent you from visiting this site where people are free to express any opinions they want; including those that are not favorable toward certain communist regimes.

    Not all sites are redlisted, you republican. Apart from that, I did not mention I am in China right now.

    This once again proves american self assurance, were actually your "regime" tries to tackle down free speech. If you are any better than us, then how comes that Interpol hunts for ->Rapists<- recently. If your "regime" is so honest, how comes the biotoxic warheads of Iraq haven't been found to date? Could it be that majority of US has been fooled?

    Laugh and get back to your chair, and enjoy the curtain of your own naiveness.

  • Katulus (unregistered)

    I almost never cry but this code put tears into my eyes.

  • Design Pattern (unregistered) in reply to shanghai coder
    shanghai coder:
    our benevolent leader came and kindly asked them to not block the entrance ... Did you see that Vader video? No? See, this is a proof.
    Obvious troll is being obvious!

    (Well that or TCM now is accompanied by another distortion of real science: New Chinese Logic).

  • Geoff W (unregistered)

    Wow that is quite the thing to have in a config file. I guess the author of the query discovered COALESCE and got really excited about it.

    The number of joins and sub selects is pretty impressive as well, I'd love to see the show plan output for that. How frequently does this query get run?

  • (cs)

    I don't see what you're complaining about.. at least it's documented with comments

  • Ryan Schipper (unregistered)

    RightFax.

    I am so sorry.

  • to moderators (unregistered)

    To moderators: Please remove all messages by Sock Puppets.

  • Marco Schramp (unregistered)

    And still, it takes more than 900 words....

  • JD (unregistered)

    You can access to my companys code repositories? ;O

  • tentacle (unregistered) in reply to Design Pattern
    Design Pattern:
    Obvious troll is being obvious!

    (Well that or TCM now is accompanied by another distortion of real science: New Chinese Logic).

    Uhm, TCM is not a distortion of "real" science, it simply is not based on the science we love so much. It is more based on empiricism. Your countertroll is therefore bullshit, especially when you come from a country politicians that have nearly 50% of votes recommend to teach god-evolution and 6k B.C. dinosaurs with equal weight and seriousness as darwin-evolution.

    Get over it.

  • (cs) in reply to Bert Glanstron
    Bert Glanstron:
    Sock Puppet 2:
    Sock Puppet 1:
    TeaDrinker:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Pope Pius X:
    98052:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Bert Glanstron:
    The Corrector:
    fake frits #17:
    ObiWayneKenobi:
    fake frits #17:
    frits:
    John Bobbit:
    Lockwood:
    Peter Johnson:
    Sock Puppets 1 and 2:
    Sock Puppet 3:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    Sock Puppet 2:
    Sock Puppet 1:
    That's funny, I thought I read this article yesterday.
    That's funny, I thought I read this comment earlier.
    My point is that they haven't published an article today.
    Then why do they call it the daily wtf?
    Good question. They have a very liberal interpretation of "daily".
    This is fun, can I play?
    No, I only have two hands.
    You have me.
    And my axe!
    Not this again...
    Who hasn't done something like this?
    I haven't.
    You have now!
    Oh, he'll.
    FTFY
    . Dear Remy,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on writing posts with sock puppets instead of posting an article clearly shows that you are too young and too stupid for unicorns.

    Go away and grow up.

    Sincerely, Bert Glanstron

    Don't say that, I love Remy!
    Me too! Especially his 'corns!
    I heard one of his posts was nominated for a Pulitzer!
    We're all just darned socks!
    I haven't been damned. Perhaps I haven't been used enough to become holy.
    FTFY
    It's all good fun until somebody gets the Pope involved.
    I guess there's more than one way to create a vertical sine wave that increases in amplitude...
    Like what, brain?
    Well an unconstrained positive feedback loop would do that for you.
    Day 3, and we're still struggling to produce a wtf.

    That is the wtf.

    Dear Sock Puppets,

    In case you haven't noticed, this is a grown-up place. The fact that you insist on playing in the comments clearly shows that you are too young and too stupid.

    Go away and grow up.

    Sincerely, Bert Glanstron

    I have quoted your quote. Pray I don't quote it further.

  • Mariusz (unregistered)

    an lovin' it.

  • (cs) in reply to Abso
    Abso:
    Abso:
    dgvid:
    In a config file?! Good grief. This is what the Windows Registry is there for people!

    Don't be silly. Registry entries are limited to 1024 characters.

    I'm afraid I owe dgvid an apology; I had registry values (which can be up to 1 MB) confused with registry key names (which are limited to 255 characters). There's no reason* this couldn't go in the registry.

    There wasn't one anyway. Just use the first character of a registry value to indicate whether it contains data, or a list of names of other keys whose content is to be concatenated. Repeat this to as many levels as you need.
  • tentacle (unregistered) in reply to ca1977a
    ca1977a:
    dgvid:
    In a config file?! Good grief. This is what the Windows Registry is there for people!

    Don't be silly. Registry entries are limited to 1024 characters.

    Don't be silly. With proper coding, you can partition values along many entries. Newbie.

  • Anon (unregistered) in reply to renewest

    Unfortunately no, it simply parses the string Document.Destination without a leading '1' and without any of the special characters in this set (' ',',','(',')',';','-','-','.','*','','/').

    Needless to say, this could probably be done a lot better...

  • 2upmedia (unregistered)

    I'm pretty sure this query takes at least 5 hours to run.

  • dh (unregistered) in reply to dgvid

    This looks like it was an entry into the Registry. I'd put it as a default value under the Windows entry; most likely in the local user section.

  • Ilya Kogan (unregistered)

    The REPLACE REPLACE REPLACE... is hillarious! I couldn't stop laughing. And then the LEFT OUTERS JOINs started... Wow! This is the funniest code I've read.

  • Overand (unregistered) in reply to BC

    Implementation of the "History Eraser Button" found!

  • Leander (unregistered)

    Will you guys please stop bashing my code? It took me years to write!

  • DW (unregistered)

    Looks like a normal Sharepoint query.

  • DW (unregistered)

    Looks like a normal Sharepoint query

Leave a comment on “All In The Config”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article