Hi, I need help on simplyfying this Update query!

Mar 19, 2008 / By Paul Vallee

Tags: , ,

I would not wish this task on my worst enemy. My friend, good luck and best wishes but I’m afraid I just can’t help you, because that much suffering is way too much for me.

Share this article

4 Responses to “Hi, I need help on simplyfying this Update query!”

  • Shakir Sadikali says:

    Haha, i was about to send this off to Rob Hamel. If he can’t do it, no one can! :-)

  • John Flack says:

    I wish that instead of giving a query that doesn’t work, people would show their data structure and explain what they need to retrieve from it. In plain language. You need to understand the problem you are trying to solve, not the failed attempts to solve it.

  • Paul Vallee says:

    John, I’m totally with you, but tell me the truth – if you took a new job or appeared at a client site and this was the task they assigned you – tell me you wouldn’t desperately clutch at straws and scratch at the coffin in hopes of getting someone else to do that for you.

  • PaulM says:

    If this is SQL 2005 use Common Table Expressions (CTE) if it is Oracle 10 use WITH …
    (which is along the same lines) and if you want, throw it through the advisors in both and see what they say.

    I agree with John and Paul, knowing what it is trying to retrieve is normally the first step to getting a handle on the SQL.

    I am worried Paul has just found a new interview question for getting a job with Pythian…
    Simplify this SQL. You have 1 hour ;)

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>